dgd1212

asked on

# Summing selections from a drop down list

I have three cells. Each have the same drop down box (list). Each selection within that list is equal to a value (PN1 is 1, PN2 is 2, PN3 is 3..., PN8 is 8).

The fourth cell displays the summation of cells 1-3.

How would a macro be written to accomplish that?

Thanks in advance

The fourth cell displays the summation of cells 1-3.

How would a macro be written to accomplish that?

Thanks in advance

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

=SUM(IFERROR(MATCH(A1:A3,D

To array-enter a formula:

1. Paste the formula in the formula bar (or click in the formula bar)

2. Hold the Control and Shift keys down

3. Hit Enter, then release all three keys

Excel should respond by adding curly braces { } surrounding your formula. If not, repeat steps 1 to 3.

SumOfDropdownChoicesQ28139167.xlsx