|
|
#4
02-10-2020, 12:57 AM
|
|||
|
|||
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!) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| OneNote on Android phone View Tags? Enter Date, Time, Date & Time | DrTwinkyEsq | OneNote | 0 | 03-27-2017 07:54 PM |
| Microsoft Project 2016 print specific date range stuck on one date | martinsalmon | Project | 1 | 10-12-2016 11:36 AM |
 date & time of last time a recent file was used
|
pgeorgilas | Word | 1 | 10-31-2014 08:59 AM |
| Greater than today at a specific time | cangelis | Excel | 6 | 10-01-2014 08:48 AM |
| Count the common time period (month) between two date period of time | Barni | Excel | 6 | 08-15-2014 07:52 AM |
Windows 8 
Office 2016
Threaded Mode