No problem .. thanks for the feedback.

"Mitch" wrote:

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.

"Toppers" wrote:

Try something like:

=SUMPRODUCT(--(C1:C10="A"),--(B1:B10),--(D1:D10))

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

HTH

"Mitch" wrote:

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