Adding cells dependent on selection in another cell

RodneyW

Active Member
Joined
Sep 24, 2010
Messages
320
My destination cell is U9. Users have an option to place an x in P9, Q9, R9 and/or S9. The can select as many or as few as they wish. If they place an x in P9 I want the value in U9 to include the value in D10. If there is an x in Q9, include/add the value in G10. If there is an x in R9, include/add the value in J10. If there is an x n M9, include/add the value in N10.

Thanks in advance
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Tetra201

MrExcel MVP
Joined
Oct 14, 2016
Messages
3,579
See if this works for you:

=SUMPRODUCT(--(P9:S9="x"),CHOOSE({1,2,3,4},D10,G10,J10,N10))
 

Watch MrExcel Video

Forum statistics

Threads
1,109,029
Messages
5,526,340
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top