I want to get the total rows in a particular column and used COUNTIF or COUNT without a result

LaurenP

The name of the text column is "Name of Service". My formula appears after the last row with data: =COUNTIF(["Name of Service"]:["Name of Service"]) and I get this error #UNPARSEABLE.

I have tried every permutation/combination and cannot figure this out.

Jon Mark H

Hey LaurenP-

I've been trying to see if I can figure this out for you -

Are you entering an argument for when it's counting in that column?

Ex: =COUNTIF(["Name of Service"]:["Name of Service"], "Room Cleaning")

The count being the number of times the service of Room Cleaning occurs in the column?

LaurenP

Thanks, Jon!. I want to count the number of rows in the Name of Service column. I need to use that total count in a dashboard.

Jon Mark H

Ah - if you want to count the number of rows - I would then just do:

=COUNTIF(["Name of Service"]:["Name of Service"], <>"")

That will count anything in that column which isn't BLANK.

-Jon Mark

LaurenP

I copied your formula and pasted it into the last cell in the Name of Service column. I see an error #UNPARSEABLE. And, when I can click Convert to Column Formula,

I see this error:

LaurenP

Jon Mark H

Ah, I think I see the issue:

Is your column named "Name of Service" or just Name of Service (without quotations)

If it's the latter, the formula will me:

=COUNTIF([Name of Service]:[Name of Service], <>"")

That should work for it.

Are you thinking you need to make this a column formula? Or were you just doing that to see if it would make the formula work?

-Jon Mark