| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
searching and summing using string within cell
Is there a way I can search on a string within a cell? I have a column of
personnel functions, column D, that includes, say, junior engineer 1, junior engineer 2, senior engineer 1....lead engineer 1, etc. I'd like to sum all the totals within another column, column K, that correlate to all juniors, all seniors etc....I'm looking for something like =sumif(cell contains "junior") Any ideas? Allan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help searching and summing across multilple worksheets | Excel Discussion (Misc queries) | |||
| searching for values and summing the corresponding values | Excel Worksheet Functions | |||
Threaded Mode
