trouble with countif

M

Mainer

I have a cell on a sheet that counts a select row for a letter
(=COUNTIF(I8:AM8,"T") ) it works great on most of the cells in the selection
but a few dont and i cant figure out why...I checked the formatting and they
-seem- to be all formatted as 'general' with nothing special attached...help
 
F

FSt1

hi
are there any unknown characters in the cell like spaces?
try the formula with a wildcard and see what happens..
=COUNTIF(I8:AM8,"T*")

Regards
FSt1
 

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

Similar Threads

Excel Use COUNTIF across a range of cells with formulas 0
countif 3
CountIf previous cell formula 0
vba countif linked to another sheet 6
Countif cell has shading 1
Help with CountIF formula 3
CountIF date problem 0
countif from whole row as range 10

Top