count
You're welcome!
Biff
"Arby" wrote in message
...
"Biff" wrote:
For the odd numbered rows:
=SUMPRODUCT(--(MOD(ROW(H3:H795)-ROW(H3),2)=0),--(H3:H795<""))
For the even numbered rows:
=SUMPRODUCT(--(MOD(ROW(H3:H795)-ROW(H3),2)=1),--(H3:H795<""))
Biff
"Arby" wrote in message
...
"Biff" wrote:
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?
That works despite myself but it appears I need a formula to count all
even rows of non blank cells and one that counts all odd rows of non
blank cells--any ideas Thx
Awesome-perfect--thank you!!
|