how do i get the sum of each alternate row in a numbers column

Hi edgewater,

Try this. Row 1 is a Header Row, Rows 10 and 11 are Footer Rows.

Formula in A2 =IF(ISODD(ROW()),"Odd","Even")

Fill down to the last Body Cell (A9 in this example)

Formula in Footer Cell A10 =SUMIF(A,"=Odd",B)

Formula in Footer Cell A11 =SUMIF(A,"=Even",B)

Regards,

Ian.

Correction:

Formula in Footer Cell B10 =SUMIF(A,"=Odd",B)

Formula in Footer Cell B11 =SUMIF(A,"=Even",B)

Thanks for the green tick!