Need help with SUMIFs

[aagrawal]

Hello,
I have never used this funtion before. Not sure if this is even th
right one. But here is what I am trying to do.
I have data on one worksheet (say deposits). The payee names, their jo
titles and payout amounts are on this worksheet. I have anothe
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
M

 

[SingleMalt]

Hello,
I have never used this funtion before. Not sure if this is even th
right one. But here is what I am trying to do.
I have data on one worksheet (say deposits). The payee names, their jo
titles and payout amounts are on this worksheet. I have anothe
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 a
well? This could be in a separate column. Hide the column if you don'
want it to be seen. Then a simple SUMIF would do the trick

 

[aagrawal]

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

Hi Me,

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

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

Cheers.

S

+-------------------------------------------------------------------
|Filename: SUMIF.txt
|Download: http://www.excelbanter.com/attachment.php?attachmentid=552
+-------------------------------------------------------------------