| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum up every other cell
Hi there, the formula i am using is
=SUMPRODUCT((MOD(ROW(G$12:G$2263),2)=0)*(G$12:G$22 63)) I need This year total in G7 and below it i need Last year total in G8 basically i want the formula to sum up every other cell so like all this year's and all last year and the layout is this year and under is last year so i am using this formula and it works but it doesnt work if there are too many rows between the range and the total. it keeps on giving me #value error thanks Veena |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
| 'IF' Macro to insert cell contents to alternate cell if cell not e | Excel Worksheet Functions | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Threaded Mode
