Thread: Min Time on Specific Date
View Single Post
 
Old 02-10-2020, 12:57 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default
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!)
Attached Files
File Type: xlsx MinStartTime.xlsx (11.7 KB, 7 views)
Reply With Quote