Thread: Total formula
View Single Post
  #1   Report Post  
Rebecca
 
Posts: n/a
Default Total formula

Hi
In B301 I need a formula that will add the contents of every 12th cell
starting at b22 and ending at b298. I am unsucessfully using
=SUMPRODUCT(C22:C296,--(MOD(ROW(C22:C296),12)+1=1))
What am I doing wrong?
Thanks!