For an explanation of the double unary minus, see
http://www.mcgimpsey.com/excel/formulae/doubleneg.html
--
David Biddulph

"HARSHAWARDHAN. S .SHASTRI"
wrote in message
...
Mike,

What is the significance of -- in formula.

Harshawardhan Shastri

"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