The Excel FIND function returns the position (as a number) of one text string inside another. When the text is not found, FIND returns a #VALUE error. Purpose Get location substring in a string Return
The criteria range for DMIN can include more than one row below the headers. When criteria includes more than one row, each row is joined with OR logic, and the expressions in a given criteria row are
The Excel MINIFS function returns the smallest numeric value that meets one or more criteria in a range of values. MINIFS can be used with criteria based on dates, numbers, text, and other conditions.
The Excel MAXIFS function returns the largest numeric value that meets one or more criteria in a range of values. MAXIFS can be used with criteria based on dates, numbers, text, and other conditions.
The generic syntax for SUMIF looks like this: = SUMIF ( range, criteria,[ sum_range]) The SUMIF function takes three arguments. The first argument, range, is the range of cells to apply criteria to. T
The SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments. The
The MOD function returns the remainder after division. For example, MOD(3,2) returns 1, because 2 goes into 3 once, with a remainder of 1. The MOD function takes two arguments: number and divisor. Num
You can use NUMBERVALUE to translate numbers from a locale-specific text format into a locale-independent number. To perform a numeric conversion, the NUMBERVALUE function uses the custom separators y
The SUMIF function is a common, widely used function in Excel, and can be used to sum cells based on dates, text values, and numbers. Note that SUMIF can only apply one condition. To sum cells using m
The MINIFS function returns the smallest numeric value that meets one or more supplied criteria. The MINIFS function can apply criteria to dates, numbers, and text. MINIFS supports logical operators (
The Excel GETPIVOTDATA function can retrieve specific data from a pivot table by name based on the structure, instead of cell references. Purpose Retrieve data from a pivot table in a formula Return v
The Excel MOD function returns the remainder of two numbers after division. For example, MOD (10,3) = 1. The result of MOD carries the same sign as the divisor. Purpose Get the remainder from division
One way to track attendance is with simple formulas based on the COUNTIF function. In the example shown, the formula in M5 is: =
This shortcut zooms out on the current worksheet, making items smaller. Note: you can also use Control + mouse scroll wheel to zoom in and out on both Windows and Mac. On Windows, the shortcut appears