Apple launches Apple Store app in India

The Apple Store app provides customers with the most personalized way to shop for Apple’s innovative lineup of products and services. Learn more >

You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

4 points

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

Posted on Apr 20, 2020 7:31 PM

Top-ranking reply

Level 7

21,391 points

Posted on Apr 21, 2020 2:35 AM

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.

View in context

Similar questions