software

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(--D618,quot;Multi-Familyquot;,SUM(E6:P18))
This gives an answer of #VALUE!=SUMPRODUCT((D618=quot;Multi-Familyquot;)*(E6:P18))

or say the drop down is in b1, use

=SUMPRODUCT((D618=B1)*(E6:P18))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;heaterquot; gt; wrote in message
...
gt; I have a column with a drop down list:
gt;
gt; Condo
gt; Multi-Family
gt; Retail - Ready
gt; Retail - Land
gt; SF Lots
gt; Industrial
gt; Mixed Use Land
gt;
gt; I need a formula when one of the drop downs is selected, it will total all
gt; the dollars associated with each selection. I have tried the following
gt; formula:
gt; =SUMPRODUCT(--D618,quot;Multi-Familyquot;,SUM(E6:P18))
gt; This gives an answer of #VALUE!
gt;
Perfect - Thanks!

quot;Bob Phillipsquot; wrote:

gt; =SUMPRODUCT((D618=quot;Multi-Familyquot;)*(E6:P18))
gt;
gt; or say the drop down is in b1, use
gt;
gt; =SUMPRODUCT((D618=B1)*(E6:P18))
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;heaterquot; gt; wrote in message
gt; ...
gt; gt; I have a column with a drop down list:
gt; gt;
gt; gt; Condo
gt; gt; Multi-Family
gt; gt; Retail - Ready
gt; gt; Retail - Land
gt; gt; SF Lots
gt; gt; Industrial
gt; gt; Mixed Use Land
gt; gt;
gt; gt; I need a formula when one of the drop downs is selected, it will total all
gt; gt; the dollars associated with each selection. I have tried the following
gt; gt; formula:
gt; gt; =SUMPRODUCT(--D618,quot;Multi-Familyquot;,SUM(E6:P18))
gt; gt; This gives an answer of #VALUE!
gt; gt;
gt;
gt;
gt;