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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum if (text meets condition)
=SUMIF(A:A,"apples",B:B)
-- __________________________________ HTH Bob "Jennifer" wrote in message ... 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 |
Reply |
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 |