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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple Excel Formula Help
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple Excel Formula Help
I am aware of the wild, that is why I used it. My question was - why would it (the formula) add 2 more entries 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple Excel Formula Help
I am aware of the wild card, that is why I used it. My question was - why would it (the formula) add 2 more entries 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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple Excel Formula Help
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 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple Excel Formula Help
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 |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple Excel Formula Help
Sorry. The formula reads 578 but the actual list contains 580. The formula reads =COUNTIF(C6:C625,"*") I have the cell range set well in advance of the current count so if it were counting any blank cells, it would be showing the total of 625. Knowing that it isnt counting blank cells, its reporting 2 less than the actual count for some reason. -- robert145 ------------------------------------------------------------------------ robert145's Profile: http://www.excelforum.com/member.php...o&userid=32477 View this thread: http://www.excelforum.com/showthread...hreadid=522657 |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Simple Excel Formula Help
What's the chance that the uncounted data is *not* text?
-- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "robert145" wrote in message ... Sorry. The formula reads 578 but the actual list contains 580. The formula reads =COUNTIF(C6:C625,"*") I have the cell range set well in advance of the current count so if it were counting any blank cells, it would be showing the total of 625. Knowing that it isnt counting blank cells, its reporting 2 less than the actual count for some reason. -- robert145 ------------------------------------------------------------------------ robert145's Profile: http://www.excelforum.com/member.php...o&userid=32477 View this thread: http://www.excelforum.com/showthread...hreadid=522657 |
Reply |
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 |