garyrobbins
asked on
How do I use SUMIF to sum time cells based on criteria table?
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=SUMIFS($B$11:$B$25;$A$11: $A$25;A4)
SUMIFS won't work in 2003 (and is unnecessary if you only have one condition!)
You're right rorya, didn't noticed that the user was using Excel 2003...
ASKER
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
Thanks too, rorya -- I appreciate your expertise.
Gary