Using VLOOKUP & SUMIF ??

I'm stuck on the proper combination of Vlookup & Sumif. In my attached spreadsheet, I'm looking for the following results

If Column D (1.20) is "PONCE", what's the Sum of HR12 (Column G) for Sunday 1/14?

Thank you!!

Although I don't know exactly where the formula should be, but I ASSUME that it should be in sheet '1.20 WAF'

Also, I don't know if you want to sum all of the week ending or just on that specific.

But I've created a formula below that only ASSUME you want to sum just the week ending (only for 1 week).

Please Login or Register  to view this content.

How would I pull only the sum of HR12's from Column G?

This is giving me an error.

If you ONLY want to pull the sum of HR12, then change $A10 to "HR12" (yes with the double quote)

Please Login or Register  to view this content.

Yes! This worked!! Thank you so much!!!!!

Your welcome.

And don't forget to mark this thread as 'Solved'