We help IT Professionals succeed at work.

How do I use SUMIF to sum time cells based on criteria table?

garyrobbins
garyrobbins asked
on
Medium Priority
369 Views
Last Modified: 2012-05-11
Hello Experts,
I've been fiddling with this problem too long trying to make a SUMIF formula to work.  I want to sum elapsed time cells based on criteria from another table.  I've attached a sample worksheet.  Can you help?

Gary
SUMIF-Help---EE.xls
Comment
Watch Question

Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Commented:
=SUMIFS($B$11:$B$25;$A$11:$A$25;A4)

Commented:
Using SUMIFS()...please check the attached file.

jppinto
SUMIF-Help---EE-1-.xls
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011

Commented:
SUMIFS won't work in 2003 (and is unnecessary if you only have one condition!)

Commented:
You're right rorya, didn't noticed that the user was using Excel 2003...

Author

Commented:
I've learned my lesson...  Why rack my brain to figure something out when I have such a talented team of experts here to help me out.  You are incredible.  Look at the response times on this question!

Thanks too, rorya -- I appreciate your expertise.

Gary
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.