I'm setting up a spreadsheet for tracking emplyee sick time and vacation hours. Underneath each employee name I have three rows, the first for date entry (no problem), the second row the number of hours taken on that particular day. The third row has a dropdown list from which may be chosen V-S-P, representing 'vacation, 'sick' and 'personal'
What formula do I use to obtain separate totals for each contigency... ie, have the counts show only those hours for vacation, those for sick time etc?
New at this so any help is greatly appreciated.
Steve
Last edited by SteveJF; 12-11-2010 at 10:23 PM.
The function you want is SUMIF(). I couldn't explain it better than Excel's own help files, press F1 and read the info on it.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Worked beautifully... thank you, Jerry!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks