Quote:
Originally Posted by aagrawal
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
|
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.