Total formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
A question you mentioned B2 to B298 but in your equation you use column C?
and mod of row 22 with 12 basis is 10

try instead

=SUM(IF(MOD(ROW(C22:C298),12)=10,C22:C298,""))
entered as an array (Control/Shift enter)

I was surprise that the sumproduct function would not work with the
correction to the mod section. but it didn't
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Questions about copying a Formula 9
Using Validation Ref # within LOOKUP 3
Adding to a SUMPRODUCT formula 6
Average ignoring Zeros 3
Please help 11
Annual Leave Summary 2
If cell not null use that value 1
What is wrong with this formula? 10

Back
Top