SUM SUMIF
Bill No. Product Qty Rate Total Amount T-shirt Total
1 Jeans 6 650 3900 3160
2 T-shirt 3 720 2160
3 Coat 5 950 4750 Maximum
4 Pants 2 680 1360 4750
5 Jacket 7 600 4200
6 Trouser 5 250 1250 Minimum
7 sweater 4 300 1200 600
8 T-shirt 2 500 1000
9 Pajamas 3 200 600 COUNT no. of numbers
10 Hat 9 150 1350 20
Grand total 21770
COUNTA no. of text
AVERAGE 10
2177
IF
Product Total Amount Prize
Jeans 650 laptop LEFT
T-shirt 720 laptop SUNDAY SUN
Coat 950 laptop MONDAY MON
Pants 680 laptop TUESDAY TUE
Jacket 600 laptop WEDNESDAY WED
Trouser 250 phone THRUSDAY THR
sweater 300 phone FRIDAY FRI
T-shirt 500 phone SATURDAY SAT
Pajamas 200 phone
Hat 150 phone TIME
2:30 AM
2:30 PM
LEN COUNTIF
ID No. digit Student mon tue wed
ax6765765 9 Mohak P A P
ax33434 7 Pragati P P A
ax77787 7 Mantesh P A A
ax2324 6 Aanchal P P P
ax233245 8
ax3332 6 PROPER UPPER
ax007 5 Name
ax1 3 mohak Mohak MOHAK SARDAL
mantesh Mantesh MANTESH SARDAL
ROMAN pragati Pragati PRAGATI SARDAL
IX aanchal Aanchal AANCHAL RAMTEKKAR
LARGE VII
4750 VII SMALL NOW
9 VI 3 12/4/2025 5:24
3900 VIII 6
VI
V Jeans 6
III T-shirt 3
Coat
TODAY Pants 2
RIGHT YESTERDAY 12/3/2025 Jacket
SARDAL DAL TODAY 12/4/2025 Trouser 5
SARDAL DAL TOMORROW 12/5/2025 sweater 0
SARDAL DAL T-shirt 2
RAMTEKKAR KAR Pajamas
Hat 9
MONTHS
DAYS MONTHS DATEDIF 9/3/2000
365 12 YEAR 25
120 4 MONTH 3
DAY 1
thu fri present absent
P A 3 2
P P 4 1
A A 1 4
P A 4 1
CONCATENATE
MOHAK SARDAL
MANTESH SARDAL
PRAGATI SARDAL
AANCHAL RAMTEKKAR
COUNTBLANK
3
Chocolate Chip Oatmeal Raisin Sugar Cookie Totals
Revenue $ 10.00 $ 8.00 $ 5.00 $ 23.00
Cost $ 4.00 $ 3.00 $ 2.00 $ 9.00
Profit $ 6.00 $ 5.00 $ 3.00 $ 14.00
Tax $ 0.60 $ 0.50 $ 0.30 $ 1.40
Profit Split $ 7.00
Tax Rate
10%
Chocolate Chip Tax Rate
Revenue 10 10%
Cost 4
Profit 6
Tax 0.6
* and / evaluated first
+ and - evaluated second
Use parentheses to control the order
Cookie Name Cookies Sold
Chocolate Chip 97 How many cookies sold? 421
Oatmeal Raisin 77 Most # of cookies sold 97
Sugar Cookie 67 Least # of cookies sold 36
Snickerdoodle 52 2nd most sold 77
Birthday Cake 52 2nd least sold 40
Peanut Butter 40 # of cookies with sales? 7
Fortune 36
7 Average sold? 60.14286
no. of cookies What # is in the middle? 52
What # occurs most frequently? 52
Country - all -
Cookie Name Sum of Cookies Sold
Birthday Cake 136
Chocolate Chip 158
Fortune 254
Oatmeal Raisin 105
Peanut Butter 89
Snickerdoodle 177
Sugar Cookie 184
Total Result 1103
Cookie Name Country Cookies Sold
Chocolate Chip United States 28 Sumif 362
Oatmeal Raisin United States 32 sumifs 28
Sugar Cookie United States 52
Snickerdoodle United States 67
Birthday Cake United States 44 Co
Peanut Butter United States 39 Averageif 120
Fortune United States 100 Averageifs
100
Chocolate Chip India 75 Countif
Oatmeal Raisin India 32 Countifs 80
Sugar Cookie India 40 Minifs 60
Snickerdoodle India 21 Maxifs
40
Birthday Cake India 58
Peanut Butter India 21 20
Fortune India 54 0
Chocolate Chip Philippines 55 ip in ie le ke er ne ip
Ch ais ook ood Ca utt rtu Ch
Oatmeal Raisin Philippines 41 e R y B e R
at l r C rd a t Fo lat eal
col ea uga icke rthd anu co
Sugar Cookie Philippines 92 o tm S Sn Bi Pe o tm S
Ch Oa Ch Oa
Snickerdoodle Philippines 89
Birthday Cake Philippines 34
Peanut Butter Philippines 29
Fortune Philippines 100
Cookies Sold
120
100
80
60
40
20
0
ip in ie le ke er ne ip in ie le ke er ne ip in ie le ke er ne
Ch ais ook ood Ca utt rtu Ch ais ook ood Ca utt rtu Ch ais ook ood Ca utt rtu
e R y B e R y B e R y B
at eal ar C kerd da ut Fo lat eal ar C kerd da ut Fo lat eal ar C kerd da ut Fo
g i c th a n co g i c th a n co g c th n
tm Su Sn Bir Pe o tm Su Sn Bir Pe o tm Su Sn Bir Pea
i
Oa Ch Oa Ch Oa
Proper
kevin cookie company
Kevin Cookie Company
Trim
Kevin Cookie Company
Kevin Cookie Company
Concat
Kevin Cookie Company
Kevin Cookie Company
&
Kevin Cookie Company
Kevin Cookie Company
Right, Left, Mid
123 Main Street, 05486 05486 123 Main Street
Len
Kevin Cookie Company 20
Find (case-sensitive) and search (not case-sensitive)
sue@[Link]
4
Left together with find
sue
True / False
Kevin Cookie Company Mrs. Fields 0 =A2=B2
10 5 0 1
11
Cookie Name Cookies Sold If
Chocolate Chip 97 Do we sell more chocolate chip or oatmeal raisin?
Oatmeal Raisin 96 Chocolate Chip =IF(B10>B11,A10,A11)
Sugar Cookie 50
AND
Does chocolate chip sell more than all other cookies?
yes =IF(AND(B10>B11,B10>
OR
Does chocolate chip sell more than oatmeal raisin or sugar?
yes =IF(OR(B10>B11,B10>B
Cookie Type Price Nested If / Ifs
Chocolate Chip 10 What is the price of:
Oatmeal Raisin 8 5 =IF(E22=A22,B22,IF(E22
Sugar Cookie 5
TRUE
=IF(B10>B11,A10,A11)
=IF(AND(B10>B11,B10>B12),"yes","no")
=IF(OR(B10>B11,B10>B12),"yes","no")
Sugar Cookie
=IF(E22=A22,B22,IF(E22=A23,B23,IF(E22=A24,B24,"unknown")))
Cookie Type Price Cost VLOOKUP
Chocolate Chip 10 4 What is the price of: Sugar Cookie
Oatmeal Raisin 8 3 5
Sugar Cookie 5 2
XLOOKUP
What is the price of: Chocolate Chip
Today
12/4/2025 12/3/2025 12/5/2025
Now
12/4/2025 5:24
Chocolate Chip Oatmeal Raisin
10 8