"smartin" wrote:

Fido wrote:
I have a worksheet that takes inventory of units that i have available to
rent. What i would like to achieve is to have excel give me a daily
percentage of my different units filled and my total units filled without
having to apply a formula per day.

For example, i have different classes of units (1 bed, 2 bed, 3 bed, etc)and
id like to know how to tell excel to look at just today's filled units vs
total units (withing classification) to give me a percent. Also, i would like
to know my total occupancy rate for all units. Hope fully this makes sense to
someone, but if not just post and ill try again.

Can you show us how your data is organized? Just post a few
representative rows and columns.




"smartin" wrote:

Fido wrote:
I have a worksheet that takes inventory of units that i have available to
rent. What i would like to achieve is to have excel give me a daily
percentage of my different units filled and my total units filled without
having to apply a formula per day.

For example, i have different classes of units (1 bed, 2 bed, 3 bed, etc)and
id like to know how to tell excel to look at just today's filled units vs
total units (withing classification) to give me a percent. Also, i would like
to know my total occupancy rate for all units. Hope fully this makes sense to
someone, but if not just post and ill try again.

Can you show us how your data is organized? Just post a few
representative rows and columns.


Sure, or at least ill try:

Columns b-g (row 1) are designated with unit class (1 bed, 2 bed, 3bed,
etc.) and each day of the month has its own row, starting at row3. Row 2 has
the total number of units for the classification (15 1-beds, 30 2-beds, 45
3-beds, etc.). Column A has the day of the month. For each day of the month,
i want to fill in the used number of units for that day. After the last day
of the month i would like a Daily Percentage row for columns b-g. I want the
daily percentage row to look at ONLY the current days worth of used units to
available units without having to change the formula every day. I do not want
a dedicated percentage column for each classification of unit, it needs to be
a row. There in lies the challenge.

Column H will be used as a Totals column. For example, H3 is used as a total
number of units for all classifications. Anything after H3 to the Daily
percentage column is used as a total occupancy rate.


Hopefully this makes a little more sense as im not sure how else to explain
it rather than post a link to the document in some fashion.