Posted by Catherine on January 29, 2002 1:59 PM
I am trying to set up a hotel booking/invoice system (assignment) on one worksheetI have columns set out as
Date Room No Service Amount
The different services are food, drink, laundry,payTv
what I want to do is when someone checks out I want to add up all the different services for the room checking out eg I want a total for food, drinks, laundry etc. I know I can use sumif to sum the individual categories but how do I link with the room numbers. Or does anyone have a working solution for a 20 room hotel.