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
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