Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif skips cells in range
i have a worksheet with this statement =COUNTIF(I9:AM9,"T") search for the #
of T's it encounters it works fine for most of the cells but cant figure out why its skipping some |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif skips cells in range
I'm guessing that there is other stuff in those cells that you think contain
plain old T (maybe trailing spaces???). I'd insert a new row 10 and add this in I10: =I9="T" and drag across. If you see a False when you expect a True, you can inspect that cell in row 9. Mainer wrote: i have a worksheet with this statement =COUNTIF(I9:AM9,"T") search for the # of T's it encounters it works fine for most of the cells but cant figure out why its skipping some -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif skips cells in range
--Make sure the cell value is 'T' and not 'T ' (T followed by a space)..
--If the data you have in the cell range is only one character you can try =COUNTIF(I9:AM9,"T*") Or =COUNTIF(I9:AM9,"*T*") If this post helps click Yes --------------- Jacob Skaria "Mainer" wrote: i have a worksheet with this statement =COUNTIF(I9:AM9,"T") search for the # of T's it encounters it works fine for most of the cells but cant figure out why its skipping some |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TAB to enter data, it skips one or more cells | Excel Worksheet Functions | |||
ENTER skips unlocked cells | Excel Discussion (Misc queries) | |||
LOOKUP skips cells | Excel Discussion (Misc queries) | |||
COUNTIF absolute value of cells in a range are 0 | Excel Discussion (Misc queries) | |||
How come when I hit tab in excel it skips several cells? | Excel Discussion (Misc queries) |