How to sum even and odd rows separately in numbers

Question

Level 1

15 points

Hi,

I'm trying to sum up all even rows and odd rows separately in numbers. I can get this to work on excel with the following formula.

=SUMPRODUCT(F2:F71,MOD(ROW(F2:F71)+1,2)) for evens

=SUMPRODUCT(F2:F71,MOD(ROW(F2:F71)+0,2)) for odds

This however is not working in numbers and keeps giving me the following error - All arguments to sumproduct must be the same length.

Is there a way to do this in numbers as I no longer have excel since switching to mac.

Many thanks

MacBook Pro with Retina display, macOS High Sierra (10.13.2)

Posted on Dec 14, 2017 2:15 AM

Reply

Answer 1

Best reply

Level 8

35,294 points

One way is to add a column and do something like this:

The formula in A2 of this example: =MOD(ROW(),2)

The formula in B9: =SUMIF(A,0,B)

The formula in B10: =SUMIF(A,1,B)

Rows 9 and 10 in this example are defined as Footer Rows.

SG

Reply

Answer 2

Level 1

15 points

That worked great,

Thank you very much for your help

Reply