View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
robert145
 
Posts: n/a
Default Simple Excel Formula Help


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