LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
converting formula from lotus.123 to excel zaharah Excel Worksheet Functions 2 July 27th 05 03:04 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
In excel the formula bar behaves differently on different machines vijay Excel Discussion (Misc queries) 0 May 20th 05 06:27 AM
Excel 2003 - Formula result shows as 0:00 Serena Excel Worksheet Functions 4 November 11th 04 10:18 PM


All times are GMT +1. The time now is 05:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"