Spreadsheet: 870546d1717052067-i-need-a-formula-for-a-complicated-if-scenario-if-possible-please-book1
Sheet: Sheet1

Date | Category | Price | Guests | Total Cost |  |  | Members | Income | Number |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
2023-10-01 00:00:00 | Seven Day Members | 20 | 2
2023-10-02 00:00:00 | Seven Day Members | 17.5 | 2 |  |  |  | Member Playing Outside Allocated Days £15
2023-10-02 00:00:00 | Six Day Members | 17.5 | 3 |  |  |  | Member Playing Outside Allocated Days £17.50
2023-10-04 00:00:00 | Seven Day Members | 17.5 | 2 |  |  |  | Member Playing Outside Allocated Days £20
2023-10-04 00:00:00 | Six Day Members | 17.5 | 2 |  |  |  | Member Playing Outside Allocated Days £35
2023-10-04 00:00:00 | Five Day Members | 17.5 | 2 |  |  |  | Total:
2023-10-04 00:00:00 | Casual Visitors - £35 | 35 | 2
2023-10-05 00:00:00 | Five Day Members | 17.5 | 3 |  |  |  | Members' Guests:
2023-10-05 00:00:00 | Seven Day Members | 17.5 | 2
2023-10-05 00:00:00 | Lady Members | 17.5 | 2 |  |  |  | Members' Guest £15 |  |  |  |  |  |  |  |  |  | 1
2023-10-06 00:00:00 | Five Day Members | 17.5 | 1 |  |  |  | Members' Guests £17.50 |  |  |  | 20 | 8 | 16 | 19 | 10 |  | 3
2023-10-06 00:00:00 | Six Day Members | 17.5 | 1 |  |  |  | Members' Guests £20 |  |  |  |  |  |  |  |  |  | 9
2023-10-06 00:00:00 | Seven Day Members | 17.5 | 1
2023-10-06 00:00:00 | Societies - £27.50 | 27.5 | 18
2023-10-08 00:00:00 | Seven Day Members | 20 | 1
2023-10-08 00:00:00 | Three Day Members | 20 | 1
2023-10-09 00:00:00 | Five Day Members | 17.5 | 2
2023-10-09 00:00:00 | Seven Day Members | 17.5 | 1
2023-10-09 00:00:00 | Casual Visitors - £35 | 35 | 2
2023-10-09 00:00:00 | Six Day Members | 17.5 | 1
2023-10-09 00:00:00 | Three Day Members | 17.5 | 1
2023-10-09 00:00:00 | Casual Visitors - £30 | 30 | 4
2023-10-09 00:00:00 | Lady Members | 17.5 | 1
2023-10-09 00:00:00 | Casual Visitors - £17.50 | 17.5 | 1
2023-10-10 00:00:00 | Six Day Members | 17.5 | 2
2023-10-10 00:00:00 | Members Playing Outside Days - £35 | 35 | 1
2023-10-12 00:00:00 | Seven Day Members | 17.5 | 4
2023-10-12 00:00:00 | Five Day Members | 17.5 | 6
2023-10-12 00:00:00 | Casual Visitors - £25 | 25 | 2
2023-10-16 00:00:00 | Five Day Members | 17.5 | 3
2023-10-16 00:00:00 | Seven Day Members | 17.5 | 1
2023-10-17 00:00:00 | Five Day Members | 17.5 | 4
2023-10-17 00:00:00 | Six Day Members | 17.5 | 1
2023-10-18 00:00:00 | Five Day Members | 17.5 | 2
2023-10-18 00:00:00 | Six Day Members | 17.5 | 3
2023-10-18 00:00:00 | Casual Visitors - £35 | 35 | 2
2023-10-19 00:00:00 | Casual Visitors - £30 | 30 | 4
2023-10-19 00:00:00 | Five Day Members | 17.5 | 2
2023-10-22 00:00:00 | Seven Day Members | 17.5 | 1
2023-10-22 00:00:00 | Seven Day Members | 20 | 2
2023-10-22 00:00:00 | Seven Day Members | 15 | 3
2023-10-22 00:00:00 | Six Day Members | 15 | 3
2023-10-23 00:00:00 | Five Day Members | 17.5 | 4
2023-10-24 00:00:00 | Seven Day Members | 17.5 | 1
2023-10-25 00:00:00 | Five Day Members | 17.5 | 2
2023-10-25 00:00:00 | Six Day Members | 17.5 | 2
2023-10-25 00:00:00 | Juniors | 17.5 | 1
2023-10-25 00:00:00 | Casual Visitors - £25 | 25 | 3
2023-10-27 00:00:00 | Seven Day Members | 17.5 | 5
2023-10-27 00:00:00 | Five Day Members | 17.5 | 1
2023-10-27 00:00:00 | Juniors | 17.5 | 1
2023-10-27 00:00:00 | Casual Visitors - £35 | 35 | 1
2023-10-30 00:00:00 | Five Day Members | 17.5 | 1