| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SUM FORMULA- skipping every seventh row
hi, i am trying to create a formula that adds up six cells in a column and gives a total in a different table, then i need it to skip the seventh cell and then add the next six and give another total, and so on..
I need a formula that i can drag down and have it autofill pretty much forever. Im on a steep excel learning curve, can someone please explain how i write a formula to skip the seventh cell? cheers |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
| How do I get a sum of every seventh cell in a column? | Excel Worksheet Functions | |||
| how to remove every seventh column from excel | Excel Discussion (Misc queries) | |||
| Skipping cells in a formula | Excel Programming | |||
| How do I delete every seventh row? | Excel Worksheet Functions | |||
Threaded Mode
