Hi all,
could someone shed some light on why my formula will not work, please?
=COUNTIFS('O Code Delays'!$N$6:$N$1689,'Dashboard Feeder'!A3,Table5[Auto fill Year],"2019/20")
the '2019/20' is stored as text but is derived ultimately from a lookup of a date value if this helps?
could someone shed some light on why my formula will not work, please?
=COUNTIFS('O Code Delays'!$N$6:$N$1689,'Dashboard Feeder'!A3,Table5[Auto fill Year],"2019/20")
the '2019/20' is stored as text but is derived ultimately from a lookup of a date value if this helps?