Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
In excel the formula bar behaves differently on different machines | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |