SUMIFS based on two criteria, dependant on result of IFERROR formula

Hi there

I have a workbook with two sheets. Sheet 1 contains data - Sheet 2 is summarising the findings of the data.

I've got an IFERROR formula in Sheet 2, column B, row 3 onward that's picking up sub-contractors based on two criteria from sheet 1 - this is working fine.

What I now want to do is calculate the total contract value in Sheet 1, column F for the sub-contractor named in Sheet 2, column B that's been added based on the above. This needs to include the same criteria as I will be adding further locations to Sheet 1 and whilst the sub-contractor's will vary they may also be listed in Sheet 1 for more than 1 location.

Any suggestions on how I can do this will be most welcome. I've highlighted in yellow on the second sheet the columns where I intend to add the formulas, B is already done. The contract value needs to populate in Sheet 2, column C - next to the contractor in column B that's been named as a result of the IFERROR formula.

Thanks!

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Thank you for updating the title.

Please attach your workbook here - the duplicate thread (which is not allowed) has been closed.

Moved to the formulas section as requested by the OP via PM.