M&Ms

	A	B			C			D			E
1		Color 1			Color 2			Color 3			Color 4
2	Name
3	Name
4	Name
5	Name
6	Name
7	Totals	=SUM(B2:B6)			=SUM(C2:C6)			=SUM(D2:D6)			=SUM(E2:E6)
8	Average	=+AVERAGE(B2:B6)			=+AVERAGE(C2:C6)			=+AVERAGE(D2:D6)			=+AVERAGE(E2:E6)
	A	B	C	D	E
1		Red	Yellow	Brown	Blue
2	Mary	12	5	21	2
3	Tom	7	7	13	8
4	Peter	5	8	34	6
5	Jose	8	12	20	4
6	Leticia	5	5	6	3
7	Totals	37	37	94	23
8	Average	7.4	7.4	18.8	4.6