Need help with SUMIFs

A

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
 
S

SingleMalt

aagrawal;1604805 said:
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
Click to expand...

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
 
A

aagrawal

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

Spencer101;1604820 said:
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
Click to expand...

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