Hi,

I'd like to sum a number of cells along a row but only if the cell two from the cell I'd use in the calculation matches a given text.

Example:

In the attached spreadsheet I'd like to use a formula to:

For Row 3:
Add the cost of all Row 3 where mechanic BK worked on the car - result would go in cell V3 (currently manually inserted - 95)
Add the cost of all Row 3 where mechanic HS worked on the car - result would go in cell W3 (currently manually inserted - 0)
Add the cost of all Row 3 where mechanic JM worked on the car - result would go in cell X3 (currently manually inserted - 85)

Thanks for your help.

Sample File: sample sheet.xlsx