hello,
i know very little about excel, but i am very good at following instructions. i was wondering if anyone could hell with a task i have.
i currently have a work book which contains data as shown in the attached jpg
the data i want to calculate is in rows 2 to 40. for the 3 price columns.
on row 41 i would like the total cost to be calculated for the cell labelled as booked, total cost for each Column listed in row 41
i also would like a graph displaying the percentage of each room Booked each year and also the total percentage of all rooms booked per year.
if anyone would be able to offer the formula i would be very grateful :-)
excell Capture.JPG
Bookmarks