| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to calculate sales tax from total sales | Excel Worksheet Functions | |||
| a formula to find total compound amount after given number of yea. | Excel Worksheet Functions | |||
| keep a running total of my formula results after each (F9) | Excel Discussion (Misc queries) | |||
| highlight cells to obtain total without using formula? | Excel Discussion (Misc queries) | |||
| Total remaining formula | Excel Worksheet Functions | |||
Threaded Mode
