Help with Sumif function please, need two criteria
Hi so I'm trying to calculate the gross pay percentage by department and person, but my sumif function is adding the total gross pay twice for different departments. I can't figure out how to have it look at two criteria instead of just one. I've attached a workbook with my problem thank you.
Last edited by JCarollo765; 05-05-2014 at 12:30 PM.
Use SUMIFS instead of SUMIF.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I don't understand how you have arrived at the figures you say you expect.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
See if this is what you are trying to achieve.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Try this in E2 & drag it down
CheersPlease Login or Register to view this content.
Phil
Those both work! Thank you
Glad to help you. Thanks for the feedback and rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks