| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing all cells containing the letter K
Hi.
I want to count all cells in a range that contains the letter K. RON BLAIR KASPER HULK FRONT KIM The example here would return 3 because 3 cells are containing a name that has K in it. I think I should put functions like SUMPRODUCT AND ISNUMBER AND MATCH, but how do I put theese together? Thanks in advance. Mvh Jan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| How can I add a single letter to text already in a list of cells? | New Users to Excel | |||
| How can I add a two letter prefix to text in cells? | Excel Discussion (Misc queries) | |||
| count cells in a coloumn with letter x in it | Excel Worksheet Functions | |||
| Count number of cells that contain a certain letter - Case Sensitive | Excel Discussion (Misc queries) | |||
Threaded Mode
