Thread: How to sum every 2nd or 3rd row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How to sum every 2nd or 3rd row
Hi,

Try this

=SUM(IF(MOD(ROW($A$1:$A$100),3)=0,$A$1:$A$100,0))
It's an arry so commit with
Ctrl+Shift+Enter

Change the 3 to a 2 to do every second row

Mike

"Mario" wrote:

How to sum every 2nd or 3rd row on the easiest way?



Reply With QuoteReply With Quote