Question

A1 x Day A fx B C D E F G H I J K Afternoon Sales over $100 Shift Cups Sold Kids Sold Kids sold Cups sold (6 oz) (12 oz) 54 52 14 28 Hours Morning Afternoon Evening 1 Day 2 Sun 3 Sun 4 Mon 5 Mon 6 Tue 7 Tue 8 Wed 9 Wed | 10 Thu | 11 Thu 12 Fri 13 Fri 14 Sat 15 Sat Morning Afternoon Afternoon Evening Afternoon Evening Afternoon Evening Afternoon Evening Afternoon Evening Morning Afternoon Profit 128.59 110.17 35.34 61.66 37.22 47.00 54.52 63.54 75.20 77.46 89.11 125.21 163.18 188.75 36 54 70 74

I need help how to do the steps 9, 10, 11

Answer 1

Here is the answer to the question asked:

Day	Shift	Kids sold(6 oz)	Cups sold(12 oz)	Profit	Afternoon Sales over $100		Hours	Kids sold	Cups sold
Sun	Morning	24	54	128.59			Morning	52	124
Sun	Afternoon	11	52	110.17	BEST		Afternoon	110	248
Mon	Afternoon	8	14	35.34			Evening	64	161
Mon	Evening	8	28	61.66
Tue	Afternoon	3	18	37.22
Tue	Evening	5	22	47.00
Wed	Afternoon	10	23	54.52
Wed	Evening	13	26	63.54
Thu	Afternoon	15	31	75.20
Thu	Evening	17	31	77.46
Fri	Afternoon	19	36	89.11
Fri	Evening	21	54	125.21
Sat	Morning	28	70	163.18
Sat	Afternoon	44	74	188.75	BEST

And here is the formulae:

Day	Shift	Kids sold(6 oz)	Cups sold(12 oz)	Profit	Afternoon Sales over $100		Hours	Kids sold	Cups sold
Sun	Morning	24	54	128.59			Morning	=+SUMIF($B$2:$C$15,H21,$C$2:$C$15)	=+SUMIF($B$2:$D$15,H21,$D$2:$D$15)
Sun	Afternoon	11	52	110.17	=+IF((AND(B22="Afternoon",E22>=100)),"BEST")		Afternoon	=+SUMIF($B$2:$C$15,H22,$C$2:$C$15)	=+SUMIF($B$2:$D$15,H22,$D$2:$D$15)
Mon	Afternoon	8	14	35.34			Evening	=+SUMIF($B$2:$C$15,H23,$C$2:$C$15)	=+SUMIF($B$2:$D$15,H23,$D$2:$D$15)
Mon	Evening	8	28	61.66
Tue	Afternoon	3	18	37.22
Tue	Evening	5	22	47
Wed	Afternoon	10	23	54.52
Wed	Evening	13	26	63.54
Thu	Afternoon	15	31	75.2
Thu	Evening	17	31	77.46
Fri	Afternoon	19	36	89.11
Fri	Evening	21	54	125.21
Sat	Morning	28	70	163.18
Sat	Afternoon	44	74	188.75	=+IF((AND(B34="Afternoon",E34>=100)),"BEST")