| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum every Nth Row (almost working)
Hi All,
Need some assistance here... This formula works... {=SUM(IF(MOD(COLUMN(D11:OFFSET(D11,0,0,1,36)),3)=0 ,D11:OFFSET(D11,0,0,1,36)),0)} Except... it's not working exactly the way I want. I need to Sum ever 3rd column but I want it to start with the first column in the range. EG: Columns D, G, J Whereas it is summing up F, I & L Any assistance to work this out would be wonderful. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Windows Query working on some computer, and not working on others?!? | Excel Programming | |||
| Calculate working days but change working week | Excel Discussion (Misc queries) | |||
| Making weekend days working days - the system cuts the working tim | Excel Discussion (Misc queries) | |||
| Newly created Get Function is not working when I copied the syntax from a working function | Excel Programming | |||
| Adding sales from a non working day to the previous working day | Excel Programming | |||
Threaded Mode
