Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trouble trying to do a 'Count IF'
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trouble shooting "COUNT" | Excel Discussion (Misc queries) | |||
dim trouble | Excel Discussion (Misc queries) | |||
more trouble with i | New Users to Excel | |||
still having trouble with this.... | Excel Worksheet Functions | |||
trouble with add ins | Excel Discussion (Misc queries) |