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