To *exclude* nulls, try this:
=COUNTIF(C6:C625,"*?")
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"RagDyeR" wrote in message
...
You say the *formula* reads 2 *more* items than actually exist,
BUT,
You also say that the formula reads 578 ... where the list contains 580 (2
*less*).
So ... which is it?
BTW, "*" will return text cells (alpha and numeric), and *also* nulls (zero
length strings) that you could have returned from formulas in those polled
cells (C6:C625), which, are of course, not visible.
--
Regards,
RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------
"robert145" wrote
in message ...
I have a simple inventory form with headings and a few simple formulas.
The problem is this. One formula is the following =COUNTIF(C6:C625,"*")
indicating Total Items for that column. The the problem is that if I
look at the end of the actual column, the number is different. Right
now the "formula" reads 578 Items, but if I look at the last item in
the column, it says 580. It always reads 2 more items than actually
exists.
--
robert145
------------------------------------------------------------------------
robert145's Profile:
http://www.excelforum.com/member.php...o&userid=32477
View this thread:
http://www.excelforum.com/showthread...hreadid=522657