=sum(a1+a3+a5+a7+a9+....etc).

Just another option. If Rng is defined similar to A1:A100, then...

=SUMPRODUCT(--(MOD(ROW(Rng),2)=1),Rng)

( =0 to sum Even Rows)

HTH :)
--
Dana DeLouis
Win XP & Office 2003


"Sarah needs to know" <Sarah needs to wrote
in message ...
I have a list of numbers all in one column and I want to be able to type in
a
formula that will SUM the numbers in every second cell only, without
having
to click on each cell individually. This is how I do it now,
=sum(a1+a3+a5+a7+a9+....etc). Is there a formula that will tell excel to
do
this automattically? If so can you tell me how to do it?