Oct 27 2021 05:26 AM
Oct 27 2021 05:59 AM
Solution@Drin16 I assume you are working on the Dashboard tab:
=COUNTIFS(Timesheet[Fleet],$A4,INDEX(Timesheet[#Data],,MATCH($N$3,Timesheet[#Headers],0)),C$3)
Oct 27 2021 06:01 AM
See the attached version.
Oct 28 2021 04:05 AM
Oct 27 2021 05:59 AM
Solution@Drin16 I assume you are working on the Dashboard tab:
=COUNTIFS(Timesheet[Fleet],$A4,INDEX(Timesheet[#Data],,MATCH($N$3,Timesheet[#Headers],0)),C$3)