Formula challenge - 2D lookup and sum

Summary

In this formula challenge, we have data showing cups of coffee sold at a small kiosk for a week. What formula will look up and sum the total cups sold after 12:00 PM on Tuesday and Thursday? Relevant cells are shaded in green.

The problem

The data below shows cups of coffee sold at a small kiosk for a week at different hours of the day. The times in column B are valid Excel times.

Lookup and sum cups after 12 PM on Tue and Thu

The challenge

What formula in cell I5 will correctly sum the total cups sold after 12:00 PM on Tuesday and Thursday? Relevant cells are shaded in green.

For your convenience, the following named ranges are available:

data = C5:G14
times = B5:B14
days = C4:G4

Download the Excel workbook, and leave your answer as a comment below.

Constraints

Your formula should dynamically locate the cells to sum, without hardcoded references. In other words, =SUM(D10:D14,F10:F14) is not valid.
Use named ranges when possible to make your formula easy to read.

Support Exceljet

Many websites (including Exceljet) have lost over half their traffic in the past year because of the crushing impact of AI on web searches. Exceljet is still at it, publishing free content each week. If you find Exceljet helpful, you can support the site and go ad-free with the Exceljet Lifetime Pass. One payment, no subscription, and ads are gone forever. Plus, you get our Excel Shortcuts video course as a thank you.