I am getting a circular refence error when i replace A1:A10 with
H3:H795 which is my range--any ideas--Thx?

Move the formula from the referenced range. In other words, don't put the
formula in a cell inside the range H3:H795.

Biff

"Arby" wrote in message
...


"Biff" wrote:

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

Biff

"Arby" wrote in message
...


"Biff" wrote:

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?


Thank you Biff--another question
How would I count everyother non blank cell? Thx


I am getting a circular refence error when i replace A1:A10 with
H3:H795 which is my range--any ideas--Thx?