Hello, I have two questions about counting the number of cells in a range?
To add to @[email protected] 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!
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
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!
@SuzanneH Happy to help!
©2022. All Rights Reserved Smartsheet Inc.