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.