So, using your formula, with my range, here's what I came up with and Excel
yelled at me -- it's not generating the correct result.

=SUM(E8:DI8*MOD(E8:DI8,2))

Do I need different parentheses or something?

"Chip Pearson" wrote:

Try the following formula. Change the cell range as desired.

=SUM(A1:A10*MOD(A1:A10,2))

A cell can contain up to 32K characters, although only about 1000
will display unless some trickery is used.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Task Lead Nicole"
wrote in message
...
Can I set up a formula in an xls to add up EVERY OTHER cell in
a row? And how
long can a string in a formula be? (are there limitations?)

I'm getting an error when I manually type in the list of cells
to add up.