SUM / AVERAGE / MAX / M
6 8 10
SUM 24 Add numbers of all cells
AVERAGE 8 Find the average of cells
MAX 10 Find highest value
MIN 6 Find Lowest value
AGE / MAX / MIN
INTEGER / ROUND / ROUNDUP/ R
7.992
INTEGER 7 Round to nearest integer
ROUND 8 Round to nereat decimal
ROUNDUP 8 Round up to nerest decimal
ROUNDDOWN 7.99 Round down to nearest decimal
D / ROUNDUP/ ROUNDDOWN
DATE / DAY / MONTH / YEAR / HOUR / NOW
9/11/2001 9
DATE 9/9/1909 Return a date based on code
DAY 11 Return day in a date
MONTH 9 Return month in a date
YEAR 2001 Return year in a date
HOUR 0 Return hour in a time
NOW 12/18/2024 23:58 Return current time and date
SECOND 0 Return second in a time
MINUTE 0 Return minute in a time
MIDDAY ヽ(￣ω￣(￣ω￣〃)ゝ
R / HOUR / NOW / SECOND / MINUTE / MIDDAY
CONCATENATE / LEFT / RIGHT / MID
Ph ong
CONCATENATE Phong Join text strings
LEFT on Return left values
RIGHT ng Return right values
MID n Return middle values
UPPER ONG Uppercase
LOWER ph Lowercase
T / RIGHT / MID / UPPER / LOWER
VLOOKUP / HLOOKUP / INDEX / LOO
1 7
2 8 2 7
3 9
VLOOKUP 8 Lookup vertically
HLOOKUP 8 Lookup horizontally
INDEX 8 Return value in array based on column and row
LOOKUP 8 Lookup generally
MATCH 2 Find value in column or row
/ INDEX / LOOKUP / MATCH
IF / COUNTA / COUNTIF / SUMIF / AVER
7 9
IF NO Check condition, return value
COUNTA 2 Count cells not blank
COUNTIF 1 Count with condition
SUMIF 7 Sum with condition
AVERAGEIF 8 Average with condition
IFERROR NO Return value instead of error message
UMIF / AVERAGEIF / IFERROR
