Thread: total column amounts from non-contiguous rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default total column amounts from non-contiguous rows
=SUM(IF(MOD(ROW(C1:C100),4)=0,C1:C100))+C1

ctrl+shift+enter, not just enter
Adjust your range to suit

"Irving" wrote:

I'm trying to total amounts in a column from rows that are not contiguous (4
rows apart). Since there are over 100 entries, I'd rather not have to "add"
each row using the simple =C1+C4+C8+C12.....etc Is there a way to do this?
Reply With QuoteReply With Quote