software

I want to search a range of cells, say C:C for a value, if that value is
there i want to multiply the corresponding B cell and D cell together then
sum up all of the true values. If anyone can help me please let me know.

Thanks

Try something like:

=SUMPRODUCT(--(C1:C10=quot;Aquot;),--(B1:B10),--(D110))

Sum the products of B*D when C=quot;Aquot;

HTH

quot;Mitchquot; wrote:

gt; I want to search a range of cells, say C:C for a value, if that value is
gt; there i want to multiply the corresponding B cell and D cell together then
gt; sum up all of the true values. If anyone can help me please let me know.
gt;
gt; Thanks

I entered your fuctions just as you wrote but it still doesn't work, I just
get a #VALUE! error. Also I'm not sure what the -- are for. Thanks for your
help so far.

quot;Toppersquot; wrote:

gt; Try something like:
gt;
gt; =SUMPRODUCT(--(C1:C10=quot;Aquot;),--(B1:B10),--(D110))
gt;
gt; Sum the products of B*D when C=quot;Aquot;
gt;
gt; HTH
gt;
gt; quot;Mitchquot; wrote:
gt;
gt; gt; I want to search a range of cells, say C:C for a value, if that value is
gt; gt; there i want to multiply the corresponding B cell and D cell together then
gt; gt; sum up all of the true values. If anyone can help me please let me know.
gt; gt;
gt; gt; Thanks

This is the function I ended up using
=IF(SUMIF(C2:C41,quot;Winter 2006quot;,E2:E41)gt;0,(SUMPRODUCT(--(C1:C41=quot;Winter
2006quot;),(B1:B41),(E1:E41))/SUMIF(C1:C41,quot;Winter 2006quot;,B1:B41)),quot;quot;)

It works perfectly, thanks for your help.

quot;Toppersquot; wrote:

gt; Try something like:
gt;
gt; =SUMPRODUCT(--(C1:C10=quot;Aquot;),--(B1:B10),--(D110))
gt;
gt; Sum the products of B*D when C=quot;Aquot;
gt;
gt; HTH
gt;
gt; quot;Mitchquot; wrote:
gt;
gt; gt; I want to search a range of cells, say C:C for a value, if that value is
gt; gt; there i want to multiply the corresponding B cell and D cell together then
gt; gt; sum up all of the true values. If anyone can help me please let me know.
gt; gt;
gt; gt; Thanks

No problem .. thanks for the feedback.

quot;Mitchquot; wrote:

gt; This is the function I ended up using
gt; =IF(SUMIF(C2:C41,quot;Winter 2006quot;,E2:E41)gt;0,(SUMPRODUCT(--(C1:C41=quot;Winter
gt; 2006quot;),(B1:B41),(E1:E41))/SUMIF(C1:C41,quot;Winter 2006quot;,B1:B41)),quot;quot;)
gt;
gt; It works perfectly, thanks for your help.
gt;
gt; quot;Toppersquot; wrote:
gt;
gt; gt; Try something like:
gt; gt;
gt; gt; =SUMPRODUCT(--(C1:C10=quot;Aquot;),--(B1:B10),--(D110))
gt; gt;
gt; gt; Sum the products of B*D when C=quot;Aquot;
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; quot;Mitchquot; wrote:
gt; gt;
gt; gt; gt; I want to search a range of cells, say C:C for a value, if that value is
gt; gt; gt; there i want to multiply the corresponding B cell and D cell together then
gt; gt; gt; sum up all of the true values. If anyone can help me please let me know.
gt; gt; gt;
gt; gt; gt; Thanks