Hi,
Please array enter (Ctrl+Shift+Enter) the following formula
SUM(IF((MOD(COLUMN(E23:I23),2)<0),E23:I23))
What this formula does is that if the column number/2<0, then it sums up
the numbers from those columns.
--
Regards,
Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com
"John Blackwell" wrote in message
...
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