"Max" wrote:
Just make it as:
=SUMPRODUCT((MOD(ROW(A2:A11),2)=0)*(A2:A11<""))
=SUMPRODUCT((MOD(COLUMN(B1:K1),2)=0)*(B1:K1<""))
("add" in the extra condition to check for non-blanks within the range)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arby" wrote:
Ths Max--How would you count everyother nonblank cell?
I am getting a circular refence error when i replace A1:A10 with
H3:H795 which is my range--any ideas--Thx?