MINIFS() is available for versions: Excel for Office 365, Excel for the web, Excel 2019. So no way to use it with MS Office 2007!
Attached is an example using dynamic Named Ranges and SUMPRODUCT(). Also I used 2 additional (helper) columns - TableRow and DateRow - which you can hide.
(I started with Defined Table and SUMIFS(), but then realized, those also aren't available for 2007 version!)
|