I don't want to have to do the +c12+e12+g12, etc.

This formula will sum every other cell starting at cell C12 to cell K12:

=SUMPRODUCT(--(MOD(COLUMN(C12:K12),2)=1),C12:K12)

This formula is the same as the above but will account for new column
insertions before the range:

=SUMPRODUCT(--(MOD(COLUMN(C12:K12)-COLUMN(C12),2)=0),C12:K12)

If you will *never* insert new columns before the range use the shorter
formula.


--
Biff
Microsoft Excel MVP


"SirMatthew" wrote in message
...
I have a spreadsheet, several, actually, that have columns containing both
numbers and dates. I want to add accross the colums, but exclude the
dates.
I didn't realize that it was adding the numeric value of the dates in my
end
formula, and I don't want to have to do the +c12+e12+g12, etc. Any
thoughts
on making this easier? I tried storing the dates as text, and that seems
to
be OK but the stupid error checking is driving me NUTS! I would like to
have
them formatted as dates, just not included.

Thanks!