Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Formula To For Every 8th Cell
Hi,
I have a worksheet with 400 tables in, all identical, and I want to add up A2, A10 A18 etc. Is there a way I can do this in a formula to save going to every 8th cell manually to add up? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Formula To For Every 8th Cell
One way
In say, B2: =SUMPRODUCT(--(MOD(ROW(A2:A100),8)=2),A2:A100) Adapt the range to suit -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "bbibib" wrote in message ... I have a worksheet with 400 tables in, all identical, and I want to add up A2, A10 A18 etc. Is there a way I can do this in a formula to save going to every 8th cell manually to add up? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Formula To For Every 8th Cell
Thanks - there are 4 numbers below each cells I want count so is it
that that is stopping it from working? It works if I have clean spreadsheet with only the cells I want populated. Rob. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum Formula To For Every 8th Cell
I'm not sure what happened/how you applied/adapted the earlier expression,
as it should add up only A2, A10, A18, etc as specified in your original post, skipping the contents of all other cells in-between. Did you apply it as-is? Or you changed the expression? Copy n paste the exact formula that you are using. -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "bbibib" wrote in message ... Thanks - there are 4 numbers below each cells I want count so is it that that is stopping it from working? It works if I have clean spreadsheet with only the cells I want populated. Rob. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
adding a formula in a cell but when cell = 0 cell is blank | Excel Worksheet Functions | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |