Spreadsheet Syntax Flashcards
COUNTIF
=COUNTIF(RANGE, “VALUE”)
SUMIF
=SUMIF(RANGE,CRITERIA/CONDITION,[SUM_RANGE])
SUMIFS
=SUMIFS(sum_range, criteria_range1, criterion1, criteria_range2, criterion2, …)
COUNTIFS
=COUNTIFS(criteria_range1, criterion1, criteria_range2, criterion2, …)
AVARAGEIF
=AVERAGEIF(range, criteria, [sum_range]
MAXIFS
=MAXIFS(max_range, range1, criteria1, range2, criteria2, …)
SUMPRODUCT
=SUMPRODUCT(ARRAY1, ARRAY2)
CONCAT
CONCAT(value1, value2)
AVERAGE
AVERAGE(value1, [value2, …])
COUNT
COUNT(value1, [value2, …])
COUNTA
COUNTA(value1, [value2, …])
MAX
MAX(value1, [value2, …])
MAXIFS
MAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)
MEDIAN
MEDIAN(value1, [value2, …])
MIN
MIN(value1, [value2, …])
MIN
MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …)
MODE
MODE(value1, [value2, …])
SUMPRODUCT
SUMPRODUCT(array1, [array2, …])
DATE
DATE(year, month, day)
DATEIF
DATEDIF(start_date, end_date, unit)
DAY
DAY(date)
DAYS
DAYS(end_date, start_date)
MONTH
MONTH(date)
UNIQUE
UNIQUE(range)
LOOKUP
LOOKUP(search_key, search_range|search_result_array, [result_range])
VLOOKUP
VLOOKUP(search_key, range, index, [is_sorted])
COUNTIF
COUNTIF(range, criterion)
LEN
LEN(text)
LOWER
LOWER(text)
UPPER
UPPER(text)
RIGHT
RIGHT(string, [number_of_characters])
SPLIT
SPLIT(text, delimiter, [split_by_each], [remove_empty_text])
TRIM
TRIM(text)
