Macro adding Sum if value is True

[sstarnes]

I need assistance creating a Macro that will consolidate information into sheet1. It will need to search column B in a separate sheet, and if the value equals the value provided in row 2 of Sheet1 it will then add the sums of column C on the separate sheet only for those rows matching in column B and provide that sum in Sheet1.

i.e in Capture 1 it shows under Truck for 3 a total of 9.42 in D3, since in the Truck sheet there are 2 lines with a value of 3 so 6+3.42=9.42

TIA

 

[sstarnes]

Answered found =SUMIF(Truck!B2:B9, "1", Truck!C2:C9)