Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add multiple values that match multiple conditions?
I have been trying to do this forever. I am using this for sales metrics,
and reporting. Here is the data Date Rep Revenue Service 01-24-2005 Joel $20 $5 01-24-2005 Bob $22 $7 01-24-2005 Joel $14 $3 01-25-2005 Joel $27 $10 01-25-2005 Joel $22 $11 Ok what I want to do is sum up how much Joel sold on 01-24-2005 ($34), So the conditions are Joel, and the date. How would you add that up without adding Bob's numbers in there? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate values in multiple values with multi conditions | Excel Worksheet Functions | |||
SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
Multiple X-Axis Values | Charts and Charting in Excel | |||
HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ? | Excel Worksheet Functions |