Good morning all,
Need some assistance for the attached file....
I need to count the "X"s in Villa Occupancy sheet based on villa number and date ranges, for example, for January 1 to 31, villas 101 to 122, total of "X"s.... Both criteria sets are in the Summary sheet for linking.
Been trying for few hours but not getting any where unfortunately.....
Many thanks in advance and wishing you all a belated happy new year !
Need some assistance for the attached file....
I need to count the "X"s in Villa Occupancy sheet based on villa number and date ranges, for example, for January 1 to 31, villas 101 to 122, total of "X"s.... Both criteria sets are in the Summary sheet for linking.
Been trying for few hours but not getting any where unfortunately.....
Many thanks in advance and wishing you all a belated happy new year !