Resource Tracker help

[alucant]

as you can see i have a table in which i have employee names & id, then i have columns where i have typed month, week, and the date- I have this so i can track where my resources are working and should be working to make the project finish on time.

I am using

=COUNTIF(Sheet2!$D$7:$D$899," ")

as to calculate the number of employees working on which projects on which day in a different sheet.
my problem is i have to handle 800+ employees and an sheet of entire year so i think writing the formula each time very inconvenient and time consuming.

I was wondering if there was a way i can just select an entire column and have its data counted with respect to the project numbers available

 

[StephenCrump]

Welcome to the Forum!

You only need one formula:

	A	B	C	D	E	F	G	H	I	J
1
2
3
4			1 Jan 2024	2 Jan 2024	3 Jan 2024	4 Jan 2024	5 Jan 2024	6 Jan 2024	7 Jan 2024	8 Jan 2024
5
6			1	1	1	1	1	1	1	1
7			1	1	2	2	2	2	2	3
8			1	1	1	3	3	3	4	4
9			2	2	2	2	2	2	2	2
10			2	2	3	3	3	3	3	3
11			3	3	4	4	4	4	4	4
12			4	4	4	4	4	4	5	5
13			5	5	5	5	5	5	5	5
14			5	5	5	5	6	6	6	6
15			6	6	6	6	6	6	6	6
16			3	3	3	3	5	5	5	5
17			2	2	2	2	3	3	3	3
18
19
20		Project	1 Jan 2024	2 Jan 2024	3 Jan 2024	4 Jan 2024	5 Jan 2024	6 Jan 2024	7 Jan 2024	8 Jan 2024
21		1	3	3	2	1	1	1	1	1
22		2	3	3	3	3	2	2	2	1
23		3	2	2	2	3	3	3	2	3
24		4	1	1	2	2	2	2	2	2
25		5	2	2	2	2	2	2	3	3
26		6	1	1	1	1	2	2	2	2
Sheet1

Cell Formulas
Range	Formula
C21:J26	C21	=COUNTIF(C$6:C$17,$B21)