I have a spreadsheet that I use for my construction company to keep track of what managers are on what jobs and how much profit our jobs are making.

In column A it has my manager's names
In column B it has my job names
Column C has my contract amount
Column D has the total amount we've billed
Column E has the total cost on the job
And Column F is my gross profit percentage

I would like this formula I'm placing under my spreadsheet to say "If Hector was the manager, this is the total of his job costs" and have the formula grab every contract amount in Column C that Hector was the manager on.

=IF(A2:A67="HL",C2:C67) ---- This is my attempt and it didn't work.

Please help me Trying to figure out if these guys deserve a raise or not.