Report? Summery Count of rows
I have a sheet that bring in once a week that has our available units and extra data. I need a report to look a this data and return a count of how many units per building are available.
Data coming in: Building | Unit Number | Rent Ready |....
I need a report to return
Building | Number of available units (count number of times a record for each building is Rent Ready)
I'm lost with this, I can manually enter each building, and then have a count, but the report I get out of our system varies what buildings are included. I need something that automatically returns the building names.