If I understand what you want,
if your output is to be a table with room type across and date down
for example roometype indicator in B101-E101
and dates in A102-A200
in B102 enter
=sumproduct((Indate range-outdate
range),--(roomtype_range=B$101),--(indate_range<=$A102),--(outdate_range=$A102))
copy and paste to B102:E200
the --( changes the logical true false to a numeric 1 0
the arrays must be the same size but cannot reference a full column for pre
2007

"KWP" wrote:

I created a spread sheet which acts as a rooming list. Columns have names,
in date out date and room type designated by a letter (theres are 4 types).
I'm going crazy trying to set a format which will automatically prepopulate
the room type code associated with a name and the dates into individual
columns (each one for a date within the span of the time people will be in
the hotel). At the bottom of each date column I have a total (which is
segmented into the various room types so that I can have a daily total sum
for each room type.