To create a data validation drop-down list in Excel, you need two things: A list of values and a blank cell to use as the data entry cell. The list is in B3:B6 and the data entry cell is D2. How ...

You can see that we simply use a plus sign to add the cell values. That formula performs the same operation as this one that uses the SUM function: =SUM(A1,B1) .