Spreadsheet: 870547d1717052595-i-need-a-formula-for-a-complicated-if-scenario-if-possible-please-book1-316-aligw
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
2023-10-06 00:00:00 | Five Day Members | 17.5 | 1 |  |  |  | Members' Guests £17.50
2023-10-06 00:00:00 | Six Day Members | 17.5 | 1 |  |  |  | Members' Guests £20
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 |  |  |  |  |  |  |  | Basically, in cell L 11 i want If(table [Date])is a Monday, table[Price] =ï¿½15 and table [Category] is not Societies or Casual Visitors,
2023-10-09 00:00:00 | Five Day Members | 17.5 | 2 |  |  |  |  |  |  |  | then insert the suming of the guests from the taable [Guests] column. If I could get the formula for one,I could work out the rest myself.
2023-10-09 00:00:00 | Seven Day Members | 17.5 | 1
2023-10-09 00:00:00 | Casual Visitors - £35 | 35 | 2 |  |  |  |  |  |  | TESTING (AliGW)
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