Sumproduct from a drop down list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column with a drop down list:

Condo
Multi-Family
Retail - Ready
Retail - Land
SF Lots
Industrial
Mixed Use Land

I need a formula when one of the drop downs is selected, it will total all
the dollars associated with each selection. I have tried the following
formula:
=SUMPRODUCT(--D6:D18,"Multi-Family",SUM(E6:P18))
This gives an answer of #VALUE!
 
=SUMPRODUCT((D6:D18="Multi-Family")*(E6:P18))

or say the drop down is in b1, use

=SUMPRODUCT((D6:D18=B1)*(E6:P18))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Perfect - Thanks!

Bob Phillips said:
=SUMPRODUCT((D6:D18="Multi-Family")*(E6:P18))

or say the drop down is in b1, use

=SUMPRODUCT((D6:D18=B1)*(E6:P18))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop-Down List 3
Multi layered drop down 1
Drop Down List 4
Excel Excel: How do I put a formula in a drop down list 11
Excel--Can you select multiple selections in a drop down list? 3
drop down list 2
produce list automatically from choice of drop down list 1
Dynamic Drop Down List 4

Back
Top