Excel Multiply Multiple Drop Down "List Boxes)

Welcome to the Forum calearoson!

If you are creating your dropboxes using Data Validation with a list, then you just use the cell references as usual.

=A1*B1*C1*D1

If you are using comboboxes it's a little different.

Can you attach your file? The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

These are not dropdown boxes. They are Forms control ListBoxes.

If you are using the same list of numbers in all of them there is no reason to repeat that list 4 times, but I'll leave that alone.

Each listbox must be linked to a cell. You did that for the first one, so I'm not sure why you didn't do it for all. I've updated them to link to B9, 12, 15, 18. You had set a value in column A and then made the font white; I just used the cells behind the listboxes.

The cell it's linked to has an index to what is selected in the list. So if you click the first value the linked cell will be 1.

To get the value that was selected, use INDEX. Then you can use the result of that in your multiplications. See formulas as added in column E.