| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif column contains text
I would like to know if there is a way in excel to sumif based on if the
data contains particular words. For example; column A has data like (blue circle, red circle, yellow circle, blue square, red square and so on.) Column B has how many of each sold. I want to sum all the rows in column A that contain a particular word (Circle, Square, Red, or Blue). I hope this makes sense and any help would be great. Thanks, Kevin |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
| Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) | |||
| Sumif based on column A and title of another column | Excel Discussion (Misc queries) | |||
| Trying to have sumif, sum by the row instead of the column | Excel Discussion (Misc queries) | |||
| Sumif where sum range is more than one column? | Excel Worksheet Functions | |||
Threaded Mode
