Hello,
I have never used this funtion before. Not sure if this is even the right one. But here is what I am trying to do.
I have data on one worksheet (say deposits). The payee names, their job titles and payout amounts are on this worksheet. I have another worksheet which maps the job titles to the department of the payee.
I need a way to report payouts by department.
Any assistance is greatly appreciated.

Regards
Me

Hi Me,

Could you post an example workbook with dummy data that represents what you're trying to acheive?

If you manually input a few of the results you're looking to get with a few brief notes that explain where they come from, if not immediately obvious, it will make it much easier to provide you with a solution.

Cheers.

S.

Can you not include the department information on the first worksheet as well? This could be in a separate column. Hide the column if you don't want it to be seen. Then a simple SUMIF would do the trick.

Thanks. Unfortunately, I do not see excel as one of the valid file types to upload. I am uploading it as text.