## Count rows that contain specific values

To count rows that contain specific values, apply the ROWCRT function or use a formula with the MMULT, TRANSPOSE, COLUMN, and SUM functions.

## Count unique text values in a range

To count unique text values in a range, you can use a formula with the SUM and COUNTIF functions.

## Get column totals

To get column totals of a range that contain numeric values, use the TOTALCOL function or a custom formula that uses the MMULT function.

## Get row totals

To get row totals of a range that contain numeric values, use the TOTALROW function or a custom formula with the MMULT function.

## Sum comma-separated values in Excel

To sum comma-separated values in Excel that are in a single cell, you can use the SUMCSV or FILTERXML functions.

## Extract common values from two lists

You can use the Excel COMPARE function to extract common values from two lists and get the result into a dynamic array.

## Count cells that do not contain errors

To count cells that do not contain errors, use the COUNTX function which works great with different data types in a given range.

## Count cells that contain specific text

To count cells that contain specific text in Excel, you can use the COUNTTEXT, COUNTIF, or SUMPRODUCT functions.

To add years to date in Excel, you can use the XDATE function instead of built-in functions like YEAR, MONTH, and DAY.

## Sum every nth row

Learn how to sum every nth row (for example, every second, third, or fifth row) in Excel using the SUMN or SUMPRODUCT function.

## Count cells not between two numbers

To count cells that are not between two numbers in Excel, you can use the NOTBETWEEN, COUNTIF, or SUMPRODUCT functions.

## Count numbers by nth digit

To count numbers where the nth digit is a given number, use the Excel COUNTDIGITS function or a formula based on MID and IFERROR functions.

## Count cells that contain text

To count cells that contain text in a range, you can use the COUNTX Excel function or the COUNTIF function with a wildcard.

## Count cells that begin with specific text

To count cells that begin with specific text in Excel, you can use the COUNTBEGIN function or the COUNTIF function.

To add leading zeros in Excel, you can use the ZFILL function, which keeps the zeros before the numeric values and convert numbers to text value.

## Sum last n columns

To sum last n columns in a range or a table, you can use the SUMCOLUMNS function in Excel instead of long formulas.

## Sum visible rows in a filtered list

To SUM visible rows in a filtered list in Excel, use the SUMVISIBLE function or the built-in SUBTOTAL or AGGREGATE functions.

## SUM if between two numbers

To sum if between in Excel, you can use the SUMBETWEEN function with two criteria or the built-in SUMIF function.

## Count cells between two numbers

To count cells between two numbers in Excel, you can use the COUNTBETWEEN function or the COUNTIFS function.

## Sum every nth column

Learn how to sum every nth column (for example, every second, third, or fifth column) using the Excel SUMCOLUMNS function.