Populating from a variable cell reference

[chocobrownie]

I'm not even too sure how to describe this so I haven't (even after an hour and a half of searching) been able to find an answer online.

I need to populate a grid for estimated monthly values of total accounts dealt with by employees in a company (the estimated monthly value of each account is in column AU, and employees have multiple accounts). The accounts referenced need to be currently stopped (identified by "Yes" in column C), and the employees names are in columm G. Obviously it's a spreadsheet in use and will be further updated.

I guess to the best of my explanation, I need to total how much estimated monthly values each employee has in accounts that are on a stopped period.

I honestly don't even know where to begin with this and every colorful description can't seem to help me find what method I can use to do this.

Any ideas?

[mrice]

Difficult to visualise what the sheet might look like but the SUMIF and SUMIFS functions might be of use.

[chocobrownie]

I came across the SUMIF function a few times and it didn't work so I deviated to an entirely new search rather than finding out if you could do multiple IFs in it - I don't know why! Long day. SUMIFS was perfect thank you very much mrice!

Hope Surrey is beautiful today Cheers