Welcome!

Odd way to emulate excel formula counta()

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)

Formulas

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

Formula Not working adding a 0
Hello I could use some help with this formula. Here is the formula I am using the bright yellow column to hold the formula. so you can see the results of that formula below =IF(ISBLANK([Initial Approval Date]@row ), " ", [Homeowner Approval Initial Status intake]@row + [Homeowner Approval Initial Status Intake 2]@row +…
Date/ Time cutoff tracking
Hi there, I've created a sheet to where my team is tracking information received. In one column, we are logging the date and time information came in (ie: November 21, 2025 8:30 AM). I would like to add a checkbox column, with a formula specifying that the box be checked if the logged time is AFTER 8:30 AM, and left…
Join-Collect from dropdown?
I have a column named Territory, where I am trying to write a formula to populate it when names are chosen from an adjacent drop-down list column called Employee Attendee. If more than one name is selected from the Employee column, I would like their respective territories to populate in the Territory field, separated by a…