I'm using COUNTIFS with named ranges which works OK on text columns but can't get date range comparison to work. Example attached
The base data contains: Department, Item, Ordered Date, Fulfilled Date and Target Date
The summary data contains: Department, Item, Count of Department and Items using COUNTIFS, Met Count which matches Department and Count and compares Fulfilled Date <= Target Date, [a %], Failed where Fulfilled Date > Target Date
My COUNTIS has a criteria against criteria range DataFulfilled with criteria "<="&DataTarget
Any help greatly appreciated
Bookmarks