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
garyrobbinsAsked:
Who is Participating?
 
StephenJRConnect With a Mentor Commented:
Try this:

=SUMIF($A$11:$A$25,A4,$B$11:$B$25)
0
 
jppintoConnect With a Mentor Commented:
You can also use SUMPRODUCT() function, like this:

=SUMPRODUCT(($A$11:$A$25=A4)*($B$11:$B$25))

Please check the attached file.

jppinto
SUMIF-Help---EE-1-.xls
0
 
jppintoCommented:
=SUMIFS($B$11:$B$25;$A$11:$A$25;A4)
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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

jppinto
SUMIF-Help---EE-1-.xls
0
 
Rory ArchibaldCommented:
SUMIFS won't work in 2003 (and is unnecessary if you only have one condition!)
0
 
jppintoCommented:
You're right rorya, didn't noticed that the user was using Excel 2003...
0
 
garyrobbinsAuthor 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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.