View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SnackFoodGirl SnackFoodGirl is offline
external usenet poster
 
Posts: 1
Default Sum of every nth cell in a column

I am trying to figure out the formula for adding the nth cell in a given
column. I am using the formula below to add every 4th cell but it is just one
that I found on line. Can someone explain to me the components of this
formula so I can adapt it?

=SUM((C2:C213) * (MOD( ROW( C2:C213)+1, 4)=0))