Thread: How do I get a sum of every seventh cell in a column?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
  
Posts: 563
Default How do I get a sum of every seventh cell in a column?
This will sum every seventh value in column A
=SUMPRODUCT(--(MOD(ROW(A1:A100),7)=1),A1:A100)
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Jubilado" wrote in message
...
Hello I am trying to find out how to get a sum of cells with a specific
fixed
interval between them

Reply With QuoteReply With Quote