Inserting a Formula into an existing Equation
I have a simple math equation in one of my cells, and in place of one of the numbers I would like to reference a count of cells with dates in them in a certain column.
My equation is: =100 - (((60 / 477) * 100)) (this returns a number in a percentage format) and I would like to replace the number "60" with this: =COUNT([Today Date]2:[Today Date]61)
I can't seem to get it to taken maybe my parenthesis placement is wrong?
I would also be fine replacing the 60 with a reference to the cell with the equation in it if that is easier, so it just pulls whatever number results from my =COUNT formula. I could not get that to take either.
I attached a screeshot, I am basically trying to get a total vacant unit count by counting the rows, and then use that number to get a total occupancy percentage
Thank you anyone who can help!
Help Article Resources
Check out the Formula Handbook template!