Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello!
Is there a way to enter a summing formula so that it looks at every 42nd cell in a range of cell e6 thru e1602 and sums each cell to a grand total? I could do =sum(e6+e48+e90............all the way to e1602, but with the size of this sheet that would take me hours.....or a whole day. I don't have that much time, and there are over 120 different columns of data I'll have to do this for...... Thanks! -- Thank you all for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Columns distributed evenly in worksheet | Excel Discussion (Misc queries) | |||
summing non-contiguous array cells | Excel Worksheet Functions | |||
Spreading 1 large number evenly into several cells | Excel Worksheet Functions | |||
Summing non contiguous cells | Excel Discussion (Misc queries) | |||
Summing non-contiguous cells | Excel Worksheet Functions |