Formulas

In this article, I will tell you how to use the excel INDEX & MATCH function to find the first non-empty cell in a row or column, it will also tell you how to use the excel LOOKUP function to find the last non-empty cell in a row or column with examples.

When you input an Excel formula in an Excel cell and execute it, you may encounter some error message like #N/A. But this kind of error message is not readable and understandable. This article will tell you how to show customized error messages to replace the default error message when the formula throws an error.

The excel MATCH function is used to find a value in a cell range, it will return the position number of the search value in the cell range. After that, we can use the Excel INDEX function and the position number to get the matched cell data. This article will tell you how to use

The Excel INDEX function is used to find a value in a specified array or one/multiple cell ranges. This article will tell you how to use the Excel index function to find data with some examples.

The Excel function SUMPRODUCT is very useful when you want to use a formula to calculate the summary of multiple number arrays. This article will tell you how to use the Excel SUMPRODUCT formula with examples.

In this article, I will tell you how to count the number of cells in a cell range that cell value between or not between 2 values ( number or date ).

In this article, I will tell you how to use the Excel formula to count less than and/or greater than operations with examples.

In the previous article, I told you how to use the Excel SUM function to add multiple cell number values in the formula. In this article, I will tell you how to use a shortcut button ( ∑ AutoSum button ) to summarize a column or a row of cell number values quickly, easily, and

In this article, I will tell you how to use formulas to add cells in Excel. The cells can be a column of cells, a row of cells, or a cell range. The formulas can use the basic cell reference or the Excel SUM function to add cell values efficiently.

This article will tell you what is the difference between unique values and distinct values in Excel, it will also tell you how to use a formula to count unique values and distinct values in Excel.