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.