| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum if (text meets condition)
Hi-
In column A I have many different names with corresponding values in column B. Q: How do add the value of column B when the name in column A is met? In example below, I'd like to be able to total B by category A. I hope this makes sense, thanks in advance. Jennifer ex. A B apples 100 tomatoes 500 peas 250 apples 500 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| list text from a cell if condition met | Excel Discussion (Misc queries) | |||
| Graphing only data that meets a condition | Charts and Charting in Excel | |||
| Identify occurence in "array" which meets condition(s) | Excel Discussion (Misc queries) | |||
| HOW DO I CORRECT A CONDITION IN WHICH ALL FORMULAS ACT LIKE TEXT? | Excel Worksheet Functions | |||
| Referencing cells text output if it meets specific conditions | Excel Worksheet Functions | |||
Threaded Mode
