Klartigue
09-19-2011, 12:23 PM
I have an excel table that has different brokers in Column A, A1 has a drop down where you can select a certain broker. In column I, there are quantities. I would like to be able to sum all the quantities for a certain broker. So I would like to use the drop down, select a broker, and have a sum function at the bottom of the page that sums the quantity for that broker. However, I would like the function to be linked to each broker so anytime you select a broker in the drop down, the sum if automatically sums all the quanitites for the selected broker.
Do you have any idea as to how to write this in excel? And i dont need a macro, just an =sumif in a cell. But im not sure how to make it automatically update when i select a different broker from the drop down.
I have attached the sheet
Do you have any idea as to how to write this in excel? And i dont need a macro, just an =sumif in a cell. But im not sure how to make it automatically update when i select a different broker from the drop down.
I have attached the sheet