Sumproduct from a drop down list

[heater]

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!

[Bob Phillips]

=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" <[email protected]> wrote in message
news:[email protected]...
> 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!
>

[heater]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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!
> >
>
>
>