Sumproduct from a drop down list
 

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 from a drop down list
 

=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)

"heater" wrote in message
...
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 from a drop down list
 

Perfect - Thanks!

"Bob Phillips" wrote:

=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)

"heater" wrote in message
...
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!