Side Work Tracker

[FrankG702]

Hi friends,

i am new to the group and excel. I have found it helpful and challenging and I love learning about it. I put a spread sheet together to track employee side work. each side work task has a number and employees write a number in the task column. three are required but most do more than that. I'm trying to figure out who has completed the most tasks, who has completed the least, which tasks are performed the most and which are performed the least. Any help would be appreciated. The image is just a few rows of the sheet. The entire thing tracks thirty days.Thanks in advance.

 

[awoohaw]

I know there are more elegant ways to do this in 365. But, here is one solution:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Date	TM	Task1	Task2	Task3	Task4	Task5	Task6	Completed
2	2023-12-10	Maria	16	14	11				41		Maria	217
3	2023-12-10	David	10	11	13				34		David	165
4	2023-12-10	Elsie	8	17	23				48		Elsie	150
5	2023-12-10	Candace	20	5	23				48		Candace	212
6	2023-12-10	Shirley	23	25	12				60		Shirley	163
7	2023-12-11	Martha	15	30	12	4			61		Martha	179
8	2023-12-11	Maria	28	6	7				41
9	2023-12-11	David	2	9	4				15
10	2023-12-11	Elsie	12	18	4	11	24		69
11	2023-12-11	Candace	25	13	3	2	3		46
12	2023-12-12	Shirley	20	22	13	22	5		82
13	2023-12-12	Martha	18	17	10	18	6		69
14	2023-12-12	Maria	15	7	18	3	22		65
15	2023-12-12	David	5	25					30
16	2023-12-12	Elsie	8	25					33
17	2023-12-13	Candace	13	24	20	6	28	27	118
18	2023-12-13	Shirley	7	14					21
19	2023-12-13	Martha	1	29	19				49
20	2023-12-13	Maria	3	16	30	21			70
21	2023-12-13	David	14	14	16	26	16		86
22
Sheet1

Cell Formulas
Range	Formula
K2:K7	K2	=UNIQUE($B$2:$B$21)
L2:L7	L2	=SUMIFS($I$2:$I$21,$B$2:$B$21,K2)
I2:I21	I2	=SUM(C2:H2)
Dynamic array formulas.