Create a cell reference. Cell references can refer to cells on the same worksheet, a different worksheet, or a different workbook.| support.microsoft.com
How to use the SUMIFS function in Excel, one of Excel’s math and trig functions, to add arguments that meet multiple criteria.| support.microsoft.com
The top reason why the #NAME? error appears in your formula is because there is a typo in the formula name. To avoid typos in formula names, use the Formula Wizard in Excel.| support.microsoft.com
Correct a #N/A error in Excel| support.microsoft.com
Use IF or IFERROR to correct a #DIV/0! error in Excel| support.microsoft.com
How to use the IF function in Excel to make logical comparisons between data values.| support.microsoft.com
Structured references make it easier to use formulas with Excel tables by replacing cell references, such as C2:C7, with predefined names for the items in a table.| support.microsoft.com
Correct a #REF! error in Excel| support.microsoft.com
The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.| support.microsoft.com
Formulas can sometimes result in error values in addition to returning unintended results. Learn about best practices to avoid those problems.| support.microsoft.com
Lists all Excel functions by their category, such as Logical functions or Text functions.| support.microsoft.com
How to use the COUNTIF function in Excel to count the number of cells that meet values you set.| support.microsoft.com
Use the COUNTBLANK function, one of the Statistical functions, to count the number of empty cells in a range of cells.| support.microsoft.com
How to use the SUM function in Excel to add individual values, cell references, ranges, or a mix of all three.| support.microsoft.com
Use a LAMBDA function to create custom, reusable functions and call them by a friendly name. The new function is available throughout the workbook and called like native Excel functions.| support.microsoft.com
How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.| support.microsoft.com