I need a productif style function

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

Guest

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="A"),--(B1:B10),--(D1:D10))

Sum the products of B*D when C="A"

HTH
 
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.
 
This is the function I ended up using
=IF(SUMIF(C2:C41,"Winter 2006",E2:E41)>0,(SUMPRODUCT(--(C1:C41="Winter
2006"),(B1:B41),(E1:E41))/SUMIF(C1:C41,"Winter 2006",B1:B41)),"")

It works perfectly, thanks for your help.
 
No problem .. thanks for the feedback.

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

It works perfectly, thanks for your help.
Click to expand...
 
You must log in or register to reply here.

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

I need a productif type function 5
Need Function Help 8
Sum a range based on another range of cells 8
Counting text cells then multiplying by a value in another column 6
Lookup returning wrong results 0
Blank Check? 1
use month in cell date to sum all relevant cells 2
Set non-continuous PrintArea via Function / Name 0

Back
Top