I have a row of drop down boxes, with only numbers in them, and I need to have a total box, but can't figure out how to do that. Any help would be appreciated. Nothing fancy, just need to sum up all numbers in the drop down box on the spreadsheet-thanks!

Click on a cell where you want the totals to be. In the formula bar type in the following: =SUM(A1:A10)

This is how you would enter the formula if you wanted to add up numbers in column A and rows 1 through 10.

Substitute the A1 with the column letter and the first row with the data, and substitute the A10 with the column letter and the last row with the data.

message edited by THX 1138

Your subject line says:

"How Do I Get A Total For Numbers In AColumnOf Drop Downs?"The first line of your post says:

"I have arowof drop down boxes..."Can you feel my confusion? :-)

message edited by DerbyDad03

I tried that, it doesn't sum up, when I update the numbers in the drop down boxes and try, it comes up "0".

sorry, it is a column of drop down boxes that I need to auto-sum, but it's like excel doesn't recognize the drop down boxes when I select the column and try to auto-sum as I would normally do, so I figure there is some kind of trick to it - lol. Thanks!

If you have a Data Validation drop box in cells A1 and B1 and C1

then the formula =SUM(A1:C1) will total the Numbers currently

occupying those three cells, unless the Data is Text.Is that what you are doing?

What

cellscontain the Data Validation drop box's?What

cell rangedoes the drop box use to get it's data from?Is all the data in the cell range Numbers or is it a mix of Numbers and Text?

MIKE

it's like excel doesn't recognize the drop down boxes when I select the column and try to auto-sumJust a thought, but do you have Automatic Calculation turned off?

For Excel 2007 to check:

Click the Microsoft Office button

Click on the Excel Options button to bring up the Excel Options dialog box (at the bottom of window)

Click on the Formulas button in the left hand pane

Under Calculation Options make sure Automatic is checked.MIKE

I placed Data Validation Drop Downs in A1:A10. They all referred to a list of values in B1:B5. I selected a value from each Drop Down.

I selected A11 and clicked the AutoSum icon.

Excel "highlighted" A1:A10 for me. I clicked the Check Mark in the formula bar and Excel summed A1:A10 in A11.

Does that process not work for you?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll