sum based on codes in 2 columns

[fayeglock]

I have 2 sheets:

Log
A B C D
Paint c 8331 20.00
Clean 8210 50.00
Water c 8315 35.00
Paint 8331 10.00

Totals (this is what I want)
A B
8210 0
8315 35.00
8331 20.00

What I want is to look in the Log and total only those rows for the codes where a 'c' is in column B.

Thanks

 

[PATSYS]

Assuming your data in the sheet TOTAL is in A1 to A3.

In cell B1 of sheet TOTAL, type this formula:

=SUMPRODUCT(--(Log!$C$1:$C$100=$A1),--(Log!$B$1:$B$100="C"),(Log!$D$1:$D$100))

Copy down.

 

[fayeglock]

Thanks so much

Assuming your data in the sheet TOTAL is in A1 to A3.

In cell B1 of sheet TOTAL, type this formula:

=SUMPRODUCT(--(Log!$C$1:$C$100=$A1),--(Log!$B$1:$B$100="C"),(Log!$D$1:$D$100))

Copy down.

Patsys - your formula worked beautifully. Thanks for your help !!