SUMIFS across 2 sheets

Hi,

I have a spreadsheet in which I am trying to show the total individual employee target per month should they match a specific criteria, i.e. length of service.

I have tried numerous ways but am clearly missing a trick as I am either giving it too few arguments or it is pulling the wrong data.

Each employee has a cohort such as 0-6, 7-12, 1, 2 & 3 years in cell HO then in HP is their target which ranges from 0-4. I am trying to pull this to the master tab in a table so it will give me the total number of the target based on each cohort. i.e.
If I had 15 employees with 2 years service with a target of 2 each month it would show a total of 30
if I had 20 employees with 3 years service with a target of 4 each month it would show a total of 100.

I hope someone might be able to assist. can give more info if required, don't know if I am on the right lines here but all my other formulas work throughout my spreadsheet but these are mainly countifs where as I think i think SUMIFs is best required here as I need the sum of the criteria not a count.


Thank you again.

So this formula is giving me the sum of the targets which is matching against HP (the target) and E119:E124 is the 0-4 range but can't get it to link right with also looking at the 0-6, 7-12, 1, 2 & 3 in HO & F119:F124

=SUMIF('FE Data'!HP:HP,Headcount!E$119:E124)

=SUMIFs('FE Data'!HP:HP,Headcount!E$119:E124, 'FE Data'!HO:HO,Headcount!F$119:F124) this returns too few arguments, I'm missing the link here in the criteria I think?

thank you all for your help, I've some how managed to make it work correctly whilst trying to create a sample spreadsheet for you!

=SUMIFS('FE Data'!HP:HP, 'FE Data'!HO:HO, Headcount!F$138:F$143)

its a very blonde day