sum of even cells & odd cells in a column

[mohadink]

Hi All;
Need formula or macro to make sum for even cells (b(x),b(x+2),B(X+3)......
And sum for odd cells
Thanks

[Glenn Kennedy]

Is this what you meant?? If data are in A1 to a6:

even rows
=SUM(IF(MOD(ROW($A$1:$A$6),2)=0,$A$1:$A$6,0))

odd rows
=SUM(IF(MOD(ROW($A$1:$A$6),2)=1,$A$1:$A$6,0))

Both are array formulae. Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...

[YasserKhalil]

May be

Please Login or Register  to view this content.

[mohadink]

Grate thanks alot

[mohadink]

Hi Mr yaser
please see the attached
something wrong ?
regards

[mohadink]

Hi Mr yaser

[YasserKhalil]

Hello Mohadin
What attachment do you mean? I didn't attach any files
Do you mean the attachment in Post # 2?

[mohadink]

yes I did applied your UDF
It gave wrong results

[Glenn Kennedy]

Mohadink. Who are you talking to?

[YasserKhalil]

If you mean the odd and even numbers themselves so use my solution
If you mean the odd and even numbers for the rows regardless the values use Mr. Glenn's solution

[mohadink]

Hi Glenn ...
your formulas are ok
thanks for your help,
the issue is the yaser's UDF is not working allright
sorry for miss understanding
regards

[mohadink]

ok
so its Mr. Glenn"s
thank you

[YasserKhalil]

You're welcome
Please mark the thread as solved

You can edit both udfs in this line

Please Login or Register  to view this content.

Replace 'Value' with 'Row'

Regards

[Glenn Kennedy]

Double post...

[Glenn Kennedy]

Glad to have helped you.