Formula

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

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.

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

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

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

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

This tutorial will show you how to calculate the running total (cumulative sum) in Excel using the RTOTAL function.

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

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

This quick guide will show you how to get the nth value in a column using the CHOOSEROWS function in Excel.

In this tutorial, you will learn how to return the nth value in a row using the CHOOSECOLS Excel function.