I'm trying figure out a formula to calculate a sum based on criteria in a single cell...
Formula I tried:PHP Code:Total Vac - Total Sick
January
Employee 1 1 2
Employee 2 2 5
March
Employee 1 5 1
Employee 2 4 0
April
May....etc
SUMIF(A3="Employee 1",SumB2:B12,0)
Obviously, this doesn't work...
I want to add the number of days a particular person takes Vacation or Sick time.
Any help is appreciated!
Last edited by FDibbins; 04-19-2013 at 07:32 PM.
you almost have it...
=SUMIF(A2:A12,"Employee 1",B2:B12)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks, it worked!
Can this same formula be used with other worksheets in the same file?
For example: SUMIF(A2:A12,B3FromAnotherWorksheet,B2:B12)
B3 from another worksheet would contain an employee name but I'd rather not be specific with the name because if that employee were to leave the company, the cell in which his name resides would be replaced by another name.
Just include the sheet name.
Let's assume the sheet name is Sheet2.
=SUMIF(A2:A12,Sheet2!B3,B2:B12)
If the sheet name contains spaces or numbers then you have to use single quotes around the sheet name like this:
sheet name: New Hires
=SUMIF(A2:A12,'New Hires'!B3,B2:B12)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Awesome! Thanks so much for your help guys
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks