This should be simple?

babycody

This should be simple?

Excel7
If you have a column of numbers and want to add every third one, what

formula do you use?

I tried stuff like

=SUMIF(A3:A13,MOD(ROW(),3)=0) as an array formula

My mind is drawing a blank. Thanks Jim

-

Bob

Registered User

Sun Jan 15 12:16:41 CST 2006

Re:This should be simple?

=SUMPRODUCT(A3:A13,--(MOD(ROW(A3:A13),3)=0))

--

HTH

RP

(remove nothere from the email address if mailing direct)

"Jim Brass" <jbrass@cfu.net>wrote in message

Quote

If you have a column of numbers and want to add every third one, what

formula do you use?

I tried stuff like

=SUMIF(A3:A13,MOD(ROW(),3)=0) as an array formula

My mind is drawing a blank. Thanks Jim