Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
I have a 2 column worksheet, & am attempting to get a count of how many rows contain certain text strings. Example: 269A560-01_39 269A560-01_41 5 269A560-01_42 269A560-01_43 269A560-01_45 269A560-01_46 269A560-01_57 The second column has a count of how many times the fragment "269A560-01_4" occurs & if I hard code that fragment into the formula, it works fine: =COUNTIF(A1:A9,"269A560-01_4"&"*") What I would like to know, is whether there a way to reference a cell number instead of hard coding the text fragment into the formula such that I could replace the above line with: =COUNTIF(A1:A9,C25 &"*") With C25 containing the actual text fragment & the count of cells in column A that contain it are returned. Thanks! -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove last character of text string | Excel Worksheet Functions | |||
text function | Excel Worksheet Functions | |||
How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
Add Function to String | Excel Worksheet Functions | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |