Formula for sum of alternate cells
Fantastic Mike - thank you.
Sorry to be a pain, but how do I sum the other cells - i.e. D23, F23, H23,
J23, L23 etc etc, up to KK23?
John
"Mike H" wrote:
John,
=SUMPRODUCT(--(MOD(COLUMN(E23:KK23),2)=1),E23:KK23)
Mike
"John Blackwell" wrote:
Folks,
I'm trying to find a formula for summing the contents of alternate cells in
a row?
I have a large workbook and want to calculate the contents of row 23 - i.e.
E23, G23, I23, K23, M23 etc etc, up to KK23. Is there a simple formula for
this?
John Blackwell
|