Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add up a value that meets 2 criteria
I have an inventory list where different people check out certain products.
I need to be able to have a formula that adds the value of a certain product for a certain salesman. This is an example of what I have. Date Product Amount salesperson 10-Oct Pencil 5 Jacob 15-Oct Pen 10 Brian 16-Oct Paper 2 Brian 20-Oct Pencil 11 Jacob 25-Oct Pencil 7 Brian and i want it to show that for this month Jacob sold a total of 16 pencils. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting a Value IF a cell meets a criteria | Excel Discussion (Misc queries) | |||
Do Nothing If Meets Criteria | Excel Discussion (Misc queries) | |||
How do I go to the next cell that meets criteria | Excel Discussion (Misc queries) | |||
SUMIF meets a criteria | Excel Worksheet Functions | |||
Max value that meets a criteria | Excel Worksheet Functions |