Ali Dharamshi
New Member
- Joined
- Apr 26, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I run a sports club and have a number of sport sessions running during the week (see calendar image) at different locations with different prices depending on what session it is but they are regular each week.
The fonts marked in red are cancelled sessions (due to various reasons) but those marked in black are what will be running as normal.
What I'm trying to do is to find a way to reconcile this with monthly invoices received from the venue or atleast work out how much it will cost before recieving the invoice for eg gents football 4x sessions in May X by £40.
So I want it to count number of sessions held in the month or in that tab which are based on 2 criteria:
1. Type of session: eg based on the text
2. Black fonted only (ignoring cancelled as will not be charged for this)
Happy to share the file if it helps
The fonts marked in red are cancelled sessions (due to various reasons) but those marked in black are what will be running as normal.
What I'm trying to do is to find a way to reconcile this with monthly invoices received from the venue or atleast work out how much it will cost before recieving the invoice for eg gents football 4x sessions in May X by £40.
So I want it to count number of sessions held in the month or in that tab which are based on 2 criteria:
1. Type of session: eg based on the text
2. Black fonted only (ignoring cancelled as will not be charged for this)
Happy to share the file if it helps