Simple Excel Formula Help

  • Thread starter Thread starter robert145
  • Start date Start date
R

robert145

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.
 
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 ~*
 
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 ?
 
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 ?
 
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 !
----------------------------------------------------------------------------
-------------------

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.
 
To *exclude* nulls, try this:

=COUNTIF(C6:C625,"*?")
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


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 !
----------------------------------------------------------------------------
-------------------

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.
 
Sorry. The formula reads 578 but the actual list contains 580. Th
formula reads =COUNTIF(C6:C625,"*") I have the cell range set well i
advance of the current count so if it were counting any blank cells, i
would be showing the total of 625. Knowing that it isnt counting blan
cells, its reporting 2 less than the actual count for some reason
 
What's the chance that the uncounted data is *not* text?
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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.
 
Back
Top