Remember that * is a wild-card. Your formula will count the number of cells
containing text between C6 and C625


If you want to count * then use ~*
--
Gary's Student


"robert145" wrote:


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