Count rows in sheet for dashboard metrics

laura.sandoval

I'm a little stuck! I have a sheet that is for Dashboard Metrics and I want to count all the rows in three different sheets to add to my dashboard.

Each sheet contains different contacts so I want to show how many contacts are in the different sheets...what formula can I use on my dashboard metrics sheet to count the numbers? This is what I have so far but it says unparseable. The name of the column I want to count is "Site Name".

Abdul Tahlil

Hi @laura.sandoval ,

Hope you are well. The formula is unparseable because you haven't defined a criteria for the range you selected.

You would want to use the COUNTIF formula to count the cells with a contact name. So the formulation would look something along the lines of: =COUNTIF([Site Name]:[Site Name], <> " ").

Best.

Abdul

laura.sandoval

This is what I have so far and it's not working :(

=COUNTIF([Site Name]:[Site Name], {Master Site Contact Sheet})

The rows I want counted are in the Site Name column coming from the sheet titled "Master Site Contact Sheet". Not entirely sure what's wrong with the formula.

laura.sandoval

laura.sandoval

Never mind I got it!! thank you!