Report - using the Summary option by Count, when the cells are blank it groups by blank but does not

Lara Lehnerz

Reports - using the Summary option by Count, when the cells are blank it groups by blank but does not count the blanks and displays '0'. I have about 200 rows that have a null value in the column I am summarizing, but the count is displayed as 0 (zero) instead of 200. How can I get the report to count the blanks?

Lara Lehnerz

Here is a screen shot for an example. The column I have it summarizing is the 2nd to last column in the peach color to the right.

Lara Lehnerz

After further testing I understand that the cells need to have data in order for the summary count function to display the number of rows. Curious though if there is a workaround to where I don't have to populate the blank cells and still have the summary count the number of empty cells?

Genevieve P.

Hi @Lara Lehnerz

What about applying the Summary COUNT to the Sheet Name column? The Sheet Name cell will always be populated if there is a row associated with your current grouping, so you should see an accurate count of rows.

Cheers!

Genevieve