Odd way to emulate excel formula counta()

L_123
✭✭✭✭✭✭
Needed to count all cells for a project, found how to do it, and am posting it here in case it helps someone else.
on range a
=countifs(A:A,@cell = @cell)
Tags:
Comments
-
Hi @L_123
Thanks for sharing!
Can I clarify, is this looking to count all cells in the column including blank cells?
=COUNT(A:A) should provide you with the number of non-blank cells.
If you're wanting to include blank cells, I had used this formula before (but your way is much cleaner!):
=COUNT(A:A) + COUNTIF(A:A, @cell = "")
Cheers 🙂
Genevieve
-
Yes, this counts all cells, including blanks
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!