Thread: This should be simple?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Brass Jim Brass is offline
external usenet poster
  
Posts: 12
Default 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


Reply With QuoteReply With Quote