Loading page...
Loading page...
Lookup, conditional, text, and date logic.
Adds values that meet a single condition.
A medium conditional total formula for multiple rules, useful when one filter is not enough to define the result.
Counts cells that satisfy a condition.
A medium counting formula for multiple conditions, useful when a row should count only if several rules are true.
A medium conditional average formula for one rule, useful when you want the mean of only the matching rows.
A medium conditional average formula for multiple rules, useful when the average should only include rows that match every filter.
A medium decision formula that turns simple rules into automatic sheet logic.
A medium decision formula that turns simple rules into automatic sheet logic.
A medium decision formula that turns simple rules into automatic sheet logic.
Looks up a value vertically in the first column of a table.
A medium lookup formula for reading values across the top row of a table and returning a lower row.
A flexible lookup function that replaces many older lookup patterns.
A medium position formula that tells you where a value appears inside a list.
Returns a value from a range using row and column positions.
A medium selection formula for returning one item from a list based on a position number.
A medium reference formula for moving from a starting cell by rows and columns to build a dynamic range.
A medium reference formula for turning text into a live cell or range reference.
Returns rows that meet a condition and spills the result automatically.
A medium dynamic array formula that reorders a list in ascending, descending, or custom order.
A medium dynamic array formula for sorting one range based on values from another range.
Returns distinct values from a list automatically.
A medium formula used by students to solve a real worksheet task with SEQUENCE.
A medium random number formula that returns a decimal between 0 and 1.
A medium random number formula for whole numbers between two limits.
A medium date formula for counting working days between two dates while skipping weekends.
A medium planning formula for moving a date forward by a set number of workdays.
A medium date difference formula for calculating age or elapsed time between two dates.
A medium date formula for jumping to the last day of a month by a given offset.
A medium date-part formula for pulling a specific piece out of a date value.
A medium date-part formula for pulling a specific piece out of a date value.
A medium date-part formula for pulling a specific piece out of a date value.
A medium date-part formula for pulling a specific piece out of a date value.
A medium date-part formula for pulling a specific piece out of a date value.
A medium data-check formula for testing what kind of value is in a cell before the next step runs.
A medium data-check formula for testing what kind of value is in a cell before the next step runs.
A medium data-check formula for testing what kind of value is in a cell before the next step runs.
A medium data-check formula for testing what kind of value is in a cell before the next step runs.
A medium reference formula for returning information about a cell such as its address or formatting.
A medium size formula for counting how many rows are in a range or array.
A medium size formula for counting how many columns are in a range or array.