Excel number arg function

How can you find out how many filled cells there are in a range?

You can do this with the aanarg function.

In this video we are going to look at this briefly with 2 examples.

Be sure to download the work file HERE

​

How do we work:

​

1. in the formula bar, type =numberarg(

2. select the number of cells, which number arg function should view

3. Press enter

​

From now on, the number of non-blank cells will be displayed.

Best of luck!

​

Did you find this video interesting?

Would you like to make a small donation?

Thanks in advance.