Count cells that contain text

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.

Add leading zeros

add leading zeros in Excel

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

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 if between two numbers

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.

Sum every nth column

sum every nth column in Excel

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

Sum every n rows

sum every n rows excel

Learn how to sum every n rows down in Excel using the SUMN_ROWS function or regular (SUM, OFFSET) functions.