Hi,
I am trying to do a summary page for an existing hotel bookings spreadsheet. I am trying to do a number of different things which is using more brainpower than I have.
1. I have a list of usual guest names all being counted using a countif formula, =COUNTIF('2016'!B:B,"=Guest A") easy enough, however I need to count the 'other' guests but as these are not a set list of data but rather a count if not one of the usual guest's I have no idea how to do this.
2. I want to see how many nights each guest has stayed in total so example guest A has 9 bookings over the year these are spread throughout the data as it is in chronological order but some might be 1 night some 2 so on and so forth. is there a way of showing this short of manual input?
There are a couple of other bits I need to look at too but to save my poor brain I will stick with these 2 to begin with.
I hope it makes sense if you need an example let me know.
thank you in advance
I am trying to do a summary page for an existing hotel bookings spreadsheet. I am trying to do a number of different things which is using more brainpower than I have.
1. I have a list of usual guest names all being counted using a countif formula, =COUNTIF('2016'!B:B,"=Guest A") easy enough, however I need to count the 'other' guests but as these are not a set list of data but rather a count if not one of the usual guest's I have no idea how to do this.
2. I want to see how many nights each guest has stayed in total so example guest A has 9 bookings over the year these are spread throughout the data as it is in chronological order but some might be 1 night some 2 so on and so forth. is there a way of showing this short of manual input?
There are a couple of other bits I need to look at too but to save my poor brain I will stick with these 2 to begin with.
I hope it makes sense if you need an example let me know.
thank you in advance