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.