| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FIND text within text then sum
Hi,
Column A contains text and numbers with some recurring text ie 1234 xxx 098 1342 xxx 878 5642 xxx 456 Column B contains a number. I need to sum column b on selected text criteria in Column A. I can't use LEN or RIGHT as the number of characters in column A are never the same and there isn't always a space between numbers and text. I thought trying to use a SUMPRODUCT with a FIND as one of the array options, but for the life of me can't make it work. Help please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find repeated text in a text document in Excel | Excel Worksheet Functions | |||
| Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
| find text in cell and replace it with part of the text in that ce. | Excel Discussion (Misc queries) | |||
| Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
| can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
Threaded Mode
