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

VLOOKUP Multiple Tables Value Return 0
countif 3
Slideshow with black border around it 0
Stuck with multi worksheet Function 8
Countif, index and match 2
trouble with (complicated) vlookup searching another workbook 2
Countif skips cells in range 2
COUNTIF accross multiple worksheets issues 4

Top