Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello All,
Is there a way to use CountIF to count any cells with a particular number or letter in the cell? I am trying to count the types of parts we have. Each type of part starts with a particular letter. So one type of parts might start with a "P", i.e. P105064 or P646546 or P797985 and another might start with "T", i.e. T1266465, T879646 or T8646377. What I need to do is count the number of different types of parts. Is there a way to count if a cell value contains a "P"? Thanks for all the help. Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED | Excel Worksheet Functions | |||
CountIf formula | Excel Discussion (Misc queries) | |||
CountIF and Sum in one formula? | Excel Worksheet Functions | |||
CountIf formula results in the formula itself being displayed. | Excel Worksheet Functions | |||
using countif into a formula | Excel Programming |