Creating DropDown list in Excel | Excel Tutorials

Creating DropDown List in Excel using Data Validation. Function 1 : SUM = Add total qty It is quite easier. Function 2 : Data Validation = DropDown List In the next cell, I want to find the total number of sales of Product from drop down list. Since Dropdown List is quick with Data Validation, Lets use SUMIF Function to find the total sales qty of corresponding item from Dropdown list. Eg. If the list has pencil, the adjoining cell should show qty sold and same for others. Let's do it. I have fixed it with F4 so the $ sign appeared which means that the range will remain fixed.