Applying a formula for daily percentages

  • Thread starter Thread starter Fido
  • Start date Start date
F

Fido

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.
 
smartin said:
Can you show us how your data is organized? Just post a few
representative rows and columns.
Click to expand...



smartin said:
Can you show us how your data is organized? Just post a few
representative rows and columns.
Click to expand...

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.
 
Back
Top