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

Weighted Average
how to get the formula to get the weighted average of the scrap
can I get automated reminders for a 30 day check in when dates in my start date column are different
I have a column titled "start date" for each of my employees. I would like a reminder sent to a manager at the 30-day mark after their hire date.
Need Help with Multiple Criteria
I need a formula that looks for the a specific person in the Ball In Court column, then look at specific status in the Comment Status column and then look at another column and if it is blank return the number. I am not sure on what this should look like for the last column.