Could someone help me with this formula. I am getting a #VALUE error.
=COUNTIFS('Workload Tracking'!C3:C38,"Active",'Workload Tracking'!F3:I38,A22)
Cell A22 contains a name that would match names in the range Workload Tracking'!F3:I38
=COUNTIFS('Workload Tracking'!C3:C38,"Active",'Workload Tracking'!F3:I38,A22)
Cell A22 contains a name that would match names in the range Workload Tracking'!F3:I38