gflory
New member
- Joined
- Feb 12, 2019
- Messages
- 2
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- Office 365
I am a real estate agent that uses an Excel spreadsheet to track real estate activity in our market. One of the measurements is called Months-Of-Inventory. This number tells me the number of months needed to sell existing inventory based on the average of previous 12 months sales. Formula is inventory divided by average of previous 12 months sales.
Here is the problem:
In one specific high-end price range, there is 19 active listings (homes for sale), but zero sales for the past 12 months. Cannot find solution to dividing a number by zero to arrive at a whole number that represents months of inventory.
Any ideas would be greatly appreciated!
Here is the problem:
In one specific high-end price range, there is 19 active listings (homes for sale), but zero sales for the past 12 months. Cannot find solution to dividing a number by zero to arrive at a whole number that represents months of inventory.
Any ideas would be greatly appreciated!