Trouble trying to do a 'Count IF'

L

Logikal1

I am trying to count the number of titles of cost entries per quarter. I
used the following formula: =COUNT (IF B6:B11= "Expenses"). The problem is
no matter how many cells I count, it invariably comes up one SHORT. B6-B11
should be 6, but the answer is always 5. [B6 is gas, b7 is electric, b8 is
telephone, b9 is food, b10 is fuel, and b11 is repairs)

Same with the other columns. =COUNT (IF C6:B14=Expenses") comes out to 8.
not 9.

I give up. What am I doing wrong?
 
M

Mike H

Hi,

It's not at all clear to me what you are trying to do but if you simply want
to count the word 'Expenses' in a range try this

=COUNTIF( B6:B14,"Expenses")

Mike
 
B

Bob Phillips

One of your entries probably has a trailing space. TRy

=COUNTIF(B6:B11,"Expenses*")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top