Je was op zoek naar: sumif (Grieks - Engels)

sumif
sumif

sumif( εύρος ελέγχου; κριτήρια; εύρος άθροισης)
sumif(checkrange; criteria; sumrange)

Η sumif(a1:a4;"1") προσθέτει όλες τις τιμές στο εύρος a1:a4 για τις οποίες ισχύει 1
sumif(a1:a4;"1") sums all values in range a1:a4 which match 1

abs, ceil, ceiling, count, counta, countblank, countif, cur, div, eps, even, exp, fact, factdouble, fib, floor, gamma, gcd, g_ product, int, inv, kproduct, lcm, ln, log, log10, log2, logn, max, maxa, mdeterm, min, mina, minverse, mmult, mod, mround, multinomial, multiply, munit, odd, pow, power, product, quotient, rand, randbernoulli, randbetween, randbinom, randexp, randnegbinom, randnorm, randpoisson, rootn, round, rounddown, roundup, seriessum, sign, sqrt, sqrtpi, subtotal, sum, suma, sumif, sumsq, transpose, truncname
abs, ceil, ceiling, count, counta, countblank, countif, cur, div, eps, even, exp, fact, factdouble, fib, floor, gamma, gcd, g_product, int, inv, kproduct, lcm, ln, log, log10, log2, logn, max, maxa, mdeterm, min, mina, minverse, mmult, mod, mround, multinomial, multiply, munit, odd, pow, power, product, quotient, rand, randbernoulli, randbetween, randbinom, randexp, randnegbinom, randnorm, randpoisson, rootn, round, rounddown, roundup, seriessum, sign, sqrt, sqrtpi, subtotal, sum, suma, sumif, sumsq, transpose, trunc