Count based on what?

Here's one way:

=SUMPRODUCT(--(MOD(ROW(A1:A10)-ROW(A1),2)=0),--(ISNUMBER(A1:A10)))

Counts every other cell starting from A1 to A10 if it contains a number.

Biff

"Arby" wrote in message
...
how would you count everyother cell?