Date Product Salesperson Units Sold Revenue

9/1/2024 Widget A Alice 10 $200 0

9/1/2024 Widget B Bob 5 $150 1
9/2/2024 Widget A Carol 7 $140 0
9/2/2024 Widget C Alice 15 $300 1
9/3/2024 Widget B Carol 8 $240 1
9/3/2024 Widget A Bob 12 $240 0
9/4/2024 Widget C Alice 6 $120 1
9/4/2024 Widget B Bob 10 $300 1
9/5/2024 Widget A Carol 8 $160 0
9/5/2024 Widget C Bob 5 $100 1

SUMIF
AVERAGEIF

$1,950
 SUMIF 740
AVERAGEIF 230
COUNTIF 7
MINIFS 120 740
MAXIFS 300
230

7
4

(CRITERIA_RANGE, CRITERIA, SUM_RANGE) 100

(CRITERIA_RANGE, CRITERIA, AVERAGE_RANGE) 300
Date Product Salesperson Units Sold Revenue
9/1/2024 Widget A Alice 10 $200
9/1/2024 Widget B Bob 5 $150
9/2/2024 Widget A Carol 7 $140
9/2/2024 Widget C Alice 15 $300
9/3/2024 Widget B Carol 8 $240
9/3/2024 Widget A Bob 12 $240
9/4/2024 Widget C Alice 6 $120
9/4/2024 Widget B Bob 10 $300
9/5/2024 Widget A Carol 8 $160
9/5/2024 Widget C Bob 5 $100
9/1/2024 Widget A Alice 10 $250
9/1/2024 Widget B Bob 5 $150
9/2/2024 Widget A Carol 7 $140
9/2/2024 Widget C Alice 15 $300
9/3/2024 Widget B Carol 8 $240
9/3/2024 Widget A Bob 12 $240
9/4/2024 Widget C Alice 6 $120
9/4/2024 Widget B Bob 10 $300
9/5/2024 Widget A Carol 8 $160
9/5/2024 Widget C Bob 5 $100

$2,910

2910
4 Sumifs 450

Averageifs 225

Countifs 2

Minifs 140

Maxifs 250

sumifs 450
1290
averageifs 225
countifs 4
REVENUE>=200,SALESPERSON-ALICE

$100

IFS(
condition1, result1,
condition2, result2,
condition3, result3,
TRUE, default_result
)
 0
1
0
0
1
1
0
1
0
1
0
1
0
0
1
1
0
1
0
1

condition1, condition2, condition3 → Logical

conditions to check.
result1, result2, result3 → Values to return
when the corresponding condition is met.
TRUE, default_result → Ensures a fallback
value if none of the conditions are met.
TODAY(): Returns the current date.
DATE(): Creates a date from year, month, and day values.
DAY(): Returns the day of the month from a date.
MONTH(): Returns the month from a date.
YEAR(): Returns the year from a date.
WEEKDAY(): Returns the day of the week as a number.
DAYS(): Returns the number of days between two dates.
NOW(): Returns the current date and time.
 3/24/2025
9/10/2024 12/1/2023
10 1
9 12
2024 2023
3 6
284
1064
3/24/2025 7:19
YEAR MONTH DAY DATE YEAR
2002 1 10 1/10/2002 2002
2000 2 1 2/1/2000 2000
2001 3 11 3/11/2001 2001

3/24/2025
2/5/2025

-47 3/24/2025 7:19

MONTH DAY WEEKDAY
1 10 2
2 1
3 11
Date Product Salesperson Units Sold Revenue q1
9/1/2024 Widget A Alice 10 $200 yes
9/1/2024 Widget B Bob 5 $150 no
9/2/2024 Widget A Carol 7 $140 yes
9/2/2024 Widget C Alice 15 $300 no
9/3/2024 Widget B Carol 8 $240 no
9/3/2024 Widget A Bob 12 $240 yes
9/4/2024 Widget C Alice 6 $120 no
9/4/2024 Widget B Bob 10 $300 no
9/5/2024 Widget A Carol 8 $160 yes
9/5/2024 Widget C Bob 5 $100 no
9/1/2024 Widget A Alice 10 $250 yes
9/1/2024 Widget B Bob 5 $150 no
9/2/2024 Widget A Carol 7 $140 yes
9/2/2024 Widget C Alice 15 $300 no
9/3/2024 Widget B Carol 8 $240 no
9/3/2024 Widget A Bob 12 $240 yes
9/4/2024 Widget C Alice 6 $120 no
9/4/2024 Widget B Bob 10 $300 no
9/5/2024 Widget A Carol 8 $160 yes
9/5/2024 Widget C Bob 5 $100 no
 q2 q3 q4 q5 q6 q7
yes 20 #NAME? -1 1290 0
0 #NAME? 1
0 #NAME? -1
0 -1
0 0
0 -1
0 -1
0 1
0 -1
0 -1
yes -1
0 1
0 -1
0 -1
0 0
0 -1
0 -1
0 1
0 -1
0 -1
q8 q9 q10 q11 q12 q13
197.5 #DIV/0! 2 600 300 300