Level 240 formulas

Data Analysis

Lookup, conditional, text, and date logic.

SUMIF

→

Adds values that meet a single condition.

=SUMIF(range, criteria, [sum_range])

SUMIFS

→

SUMIFS is a medium formula used in professional spreadsheet workflows.

=SUMIFS(...)

COUNTIF

→

Counts cells that satisfy a condition.

=COUNTIF(range, criteria)

COUNTIFS

→

COUNTIFS is a medium formula used in professional spreadsheet workflows.

=COUNTIFS(...)

AVERAGEIF

→

AVERAGEIF is a medium formula used in professional spreadsheet workflows.

=AVERAGEIF(...)

AVERAGEIFS

→

AVERAGEIFS is a medium formula used in professional spreadsheet workflows.

=AVERAGEIFS(...)

IFERROR

→

IFERROR is a medium formula used in professional spreadsheet workflows.

=IFERROR(...)

IFS

→

IFS is a medium formula used in professional spreadsheet workflows.

=IFS(...)

SWITCH

→

SWITCH is a medium formula used in professional spreadsheet workflows.

=SWITCH(...)

VLOOKUP

→

Looks up a value vertically in the first column of a table.

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

HLOOKUP

→

HLOOKUP is a medium formula used in professional spreadsheet workflows.

=HLOOKUP(...)

XLOOKUP

→

A flexible lookup function that replaces many older lookup patterns.

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

MATCH

→

MATCH is a medium formula used in professional spreadsheet workflows.

=MATCH(...)

INDEX

→

Returns a value from a range using row and column positions.

=INDEX(array, row_num, [column_num])

CHOOSE

→

CHOOSE is a medium formula used in professional spreadsheet workflows.

=CHOOSE(...)

OFFSET

→

OFFSET is a medium formula used in professional spreadsheet workflows.

=OFFSET(...)

INDIRECT

→

INDIRECT is a medium formula used in professional spreadsheet workflows.

=INDIRECT(...)

FILTER

→

Returns rows that meet a condition and spills the result automatically.

=FILTER(array, include, [if_empty])

SORT

→

SORT is a medium formula used in professional spreadsheet workflows.

=SORT(...)

SORTBY

→

SORTBY is a medium formula used in professional spreadsheet workflows.

=SORTBY(...)

UNIQUE

→

Returns distinct values from a list automatically.

=UNIQUE(array, [by_col], [exactly_once])

SEQUENCE

→

SEQUENCE is a medium formula used in professional spreadsheet workflows.

=SEQUENCE(...)

RAND

→

RAND is a medium formula used in professional spreadsheet workflows.

=RAND(...)

RANDBETWEEN

→

RANDBETWEEN is a medium formula used in professional spreadsheet workflows.

=RANDBETWEEN(...)

NETWORKDAYS

→

NETWORKDAYS is a medium formula used in professional spreadsheet workflows.

=NETWORKDAYS(...)

WORKDAY

→

WORKDAY is a medium formula used in professional spreadsheet workflows.

=WORKDAY(...)

DATEDIF

→

DATEDIF is a medium formula used in professional spreadsheet workflows.

=DATEDIF(...)

EOMONTH

→

EOMONTH is a medium formula used in professional spreadsheet workflows.

=EOMONTH(...)

YEAR

→

YEAR is a medium formula used in professional spreadsheet workflows.

=YEAR(...)

MONTH

→

MONTH is a medium formula used in professional spreadsheet workflows.

=MONTH(...)

DAY

→

DAY is a medium formula used in professional spreadsheet workflows.

=DAY(...)

WEEKDAY

→

WEEKDAY is a medium formula used in professional spreadsheet workflows.

=WEEKDAY(...)

WEEKNUM

→

WEEKNUM is a medium formula used in professional spreadsheet workflows.

=WEEKNUM(...)

ISBLANK

→

ISBLANK is a medium formula used in professional spreadsheet workflows.

=ISBLANK(...)

ISNUMBER

→

ISNUMBER is a medium formula used in professional spreadsheet workflows.

=ISNUMBER(...)

ISTEXT

→

ISTEXT is a medium formula used in professional spreadsheet workflows.

=ISTEXT(...)

ISERROR

→

ISERROR is a medium formula used in professional spreadsheet workflows.

=ISERROR(...)

CELL

→

CELL is a medium formula used in professional spreadsheet workflows.

=CELL(...)

ROWS

→

ROWS is a medium formula used in professional spreadsheet workflows.

=ROWS(...)

COLUMNS

→

COLUMNS is a medium formula used in professional spreadsheet workflows.

=COLUMNS(...)

Loading page...