ExcelBanter - This should be simple?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - This should be simple? (https://www.excelbanter.com/excel-programming/350481-should-simple.html)

Jim Brass

This should be simple?

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 Phillips[_6_]

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" wrote in message
...
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

All times are GMT +1. The time now is 07:20 AM.