How do i find the occupancy rate for multiple lots? This spreadsheets contains more lots than given. I only provided are part of lot 1 and a part of lot 2 because the file is too large. They all run...

How do i find the occupancy rate for multiple lots? This spreadsheets contains more lots than given. I only provided are part of lot 1 and a part of lot 2 because the file is too large. They all run together in one file and need the occupancy rate which is column D on my spreadsheet.