1

Under Excel, there's something like = Sumproduct((A1:A100),--(A1:A100<>"")) from Excel formula -> how to change SUMPRODUCT formula to skip null cells

But it did not work for Numbers. Wondering if there's a good way to achieve it using Numbers

E.g. I would like to do the sumproduct of following two columns, but only if the value of the second column is greater than 1

1 1

2 2

3 3

4 4

5 5

  • isn't the sum of zeros , zero ! – Ruskes Jul 5 '15 at 22:23
  • I did not get your point, what did you mean. – cheneychen Jul 6 '15 at 0:32
  • turned out sumproduct will automatically exclude empty cell, then what if we would like to conditionally exclude cells for sumproduct? – cheneychen Jul 6 '15 at 0:33
  • did you end up founding a solution for this @cheneychen? I'm looking for the exact same solution: superuser.com/questions/971060/… – zerohedge Sep 10 '15 at 12:54

You must log in to answer this question.

Browse other questions tagged .