SEQUENCE is the function that will generate the list of numbers, and COUNTA, the first argument of the SEQUENCE formula, will count the number of non-blank cells in the range B2 to B901.

In Microsoft Excel, there is a group of functions that count values in a cell, namely, COUNT, COUNTA, COUNTBLANK, and COUNTIF. COUNT: Count how many numbers are in the list of arguments.

Let’s start. 1] Count nonblank cells in Excel by using the COUNTA function In Microsoft Excel, the COUNTA is the function that is used to count the cells that contain some values.

You can't use a SUM() function to sum a filtered list, unless you intend to evaluate hidden and unhidden values. Here's how to sum only the values that meet your filter's criteria.