How to count number of cells in a range

SuzanneH

Hello, I have two questions about counting the number of cells in a range?

1. How do I count all cells in a range, whether or not they have a value in them? COUNTM seems to exclude blanks.
2. Can I do they same for a list that is not a range?

Thanks,

Suzanne

Andrée Starå

Hi @SuzanneH,

To add to @Nasir@EBC excellent suggestion.

Here's another option.

Try something like this.

=COUNTIF(Column:Column; OR(ISBLANK(@cell); NOT(ISBLANK(@cell))))

The same version but with the below changes for your and others convenience.

=COUNTIF(Column:Column, OR(ISBLANK(@cell), NOT(ISBLANK(@cell))))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Nasir@EBC

Hello Suzanne

You can use the following formula to count all the cells whether they have any value or are blank:

=COUNTIF([Column Name]1:[Column Name]10, OR(LEN(@cell) = 0, LEN(@cell) > 0))

Please replace the column name and range according to your requirements.

Hope this helps!

Best

Nasir (Zealvert)

Andrée Starå

Hi @SuzanneH,

To add to @Nasir@EBC excellent suggestion.

Here's another option.

Try something like this.

=COUNTIF(Column:Column; OR(ISBLANK(@cell); NOT(ISBLANK(@cell))))

The same version but with the below changes for your and others convenience.

=COUNTIF(Column:Column, OR(ISBLANK(@cell), NOT(ISBLANK(@cell))))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SuzanneH

Thank you!

Andrée Starå

@SuzanneH Happy to help!