Counting blank cells in a report

Lisa Welch

I have 23 sheets and need to set up a report that includes count of the number of projects. I summarized the project name column and chose count, however it is counting the line that contains the sheet heading. How do I have it NOT count that row in the report?

Thank you,

Paul Newcome

Are you able to provide a screenshot for context?

Lisa Welch

Thanks Paul, I actually got it sorted out.

Andrée Starå

Hi @Lisa Welch

I hope you're well and safe!

Excellent! Glad you got it working!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Glad you were able to get it sorted.

Are you able to provide the solution and mark it as the accepted answer in case anyone else is looking for some help with the same thing?