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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum up every other cell
it doesnt work if there are too many rows between
the range and the total. it keeps on giving me #value error The number of rows has nothing to do with it. You'll get a #VALUE! error is any of the even numbered cells have TEXT in them or, if *any* cells already contain a #VALUE! error. Try it like this: =SUMPRODUCT(--(MOD(ROW(G$12:G$2263),2)=0),G$12:G$2263) That will still return an error if *any* cells already contain a #VALUE! error. -- Biff Microsoft Excel MVP "veena" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum up every other cell
You can always use amn auxilary column.
Put in an unued column the formula =mod(row(),2) The use Sumif and the use for the condition the new column = 1 =sumif(IV$12:IV$2263,0,G$12:G$2263) "veena" wrote: 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 |
Reply |
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) |