Thread: count
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
Arby Arby is offline
external usenet poster
 
Posts: 8
Default count



"Max" wrote:

Place the formula in a cell outside the range
- this is the normal assumption <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Arby" wrote:
I am getting a circular reference 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