How do I get a total for numbers in a column of drop downs?

October 13, 2015 at 12:20:39
Specs: Excel
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!

See More: How do I get a total for numbers in a column of drop downs?

Report •


#1
October 13, 2015 at 13:52:58
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


Report •

#2
October 14, 2015 at 06:49:38
Your subject line says:

"How Do I Get A Total For Numbers In A Column Of Drop Downs?"

The first line of your post says:

"I have a row of drop down boxes..."

Can you feel my confusion? :-)

message edited by DerbyDad03


Report •

#3
October 15, 2015 at 04:54:03
I tried that, it doesn't sum up, when I update the numbers in the drop down boxes and try, it comes up "0".


Report •

Related Solutions

#4
October 15, 2015 at 04:55:26
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!

Report •

#5
October 15, 2015 at 07:36:00
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 cells contain the Data Validation drop box's?

What cell range does 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

http://www.skeptic.com/


Report •

#6
October 15, 2015 at 08:31:22
it's like excel doesn't recognize the drop down boxes when I select the column and try to auto-sum

Just 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

http://www.skeptic.com/


Report •

#7
October 15, 2015 at 08:36:12
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.


Report •


Ask Question