SUMIF Using Multiple Criteria

I have data in one column that I'd like to SUM however certain criteria needs to be met.

I've used the following formula to date but am not getting any result.

SUMPRODUCT(--(G2:G105),--(A2:A105=317),--(E2:E105=K9),--(E2:E105=K5),--(E2:E105=K7))

K9 = Reseach
K7 = Lunch
K5 = Break

Here is the data in question.

Column G (Busy Time) contains the data I'd like to SUM. I'm looking to have the formula look at the busy code then add up the times of specific codes. For instance give me the SUM of times for Busy codes(column D) 3, 4 and 7 for Joe. The issue is that Joe isn't the only agent. Several are listed with their IDs showing in Column A. Each agent shows the same info but with their name and ID listed in Columns A and B. The number of codes listed can also change via agent. In Joe's case he has 8 codes listed but there are some agents that only 4, however all will have 3, 4 and 7.

ID Name Total shift Busy code Busy reason Busy count Busy time

317 Joe 3:50:01 0 No Code 29 0:36:42
317 3:50:01 -1 System Code 3 0:00:09
317 3:50:01 2 Meeting 1 0:38:04
317 3:50:01 3 Break 17 3:51:36
317 3:50:01 8 Callouts 1 0:02:17
317 3:50:01 4 Lunch 12 4:54:43
317 3:50:01 1 Training 18 8:21:39
317 3:50:01 7 Research 45 2:32:45

Anyway, as you can see, I'm in a pickle.

Thanks!

JT

Good point, would you prefer to see a copy of the actual Excel form? How do I post an attachment?

Thanks!

JT

All righty, the sheet has been attached. Hope I did that correctly?

JT

hmm, well not sure how it would work as I need to sum up only certain make busy code reasons, not all. Thoughts.

Aha! Actually you are correct, I can restrict it to certain criteria via a Pivot Table. Very cool.