Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Add a Dynamic Range with 2 Conditions Q
I have a Range area which is dynamic and I wish to create a formula that
will add up values within this dynamic range if two conditions exist Col A = Location Col C = Product Number Col E = Sales Units (of the products in Col C that have been sold in Col A - location) I only wish to add some of the products that are listed, not all. Therefore is cell A1 on Sheet1 I want to create a formula that will do the following Add up all quantities that are in Col E that relate to Product Number "43", that are sold at Location - "London" How can I do that? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
Dynamic Range Problem | Excel Discussion (Misc queries) | |||
How do I sum a range after 2 different conditions are met (2 colu. | Excel Discussion (Misc queries) | |||
named range refers to: in a chart | Excel Discussion (Misc queries) | |||
range names | Excel Worksheet Functions |