| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
=countif(range,"*jack")
range means the range of cells containsing the dta like 7pmM jack for e.g. if your data is in A1 to A10 the formula is =countif(a1:a10,"*jack") note the star symbol. that is wild card any entry with Jack. ============= -- remove $$$ from email addresss to send email ======== "bschute" wrote in message ... I have several columns with 7pmM Jack or simialr enteries. How do I get a sum of all Jack names in each column-- probably need an If statement -which one, What characters preceed and follow the name e.g."*etc.  -- bschute ------------------------------------------------------------------------ bschute's Profile: http://www.excelforum.com/member.php...o&userid=27349 View this thread: http://www.excelforum.com/showthread...hreadid=468579 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Hybrid Mode
