candymycandy
New Member
- Joined
- Jun 14, 2022
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
Hi all
I need help with a formula please.
I have an events spreadsheet:
Tab 1: A user enters event/delegate details and notes whether the event is training or a conference.
Tab 2: Financial info on how much each company has spent on tickets
Tab 3: Training and conference events have a ticket cost filled in here (to allow this to be easily amended each year).
In tab 2 I need to evaluate how much each company who sends attendees to the event has spent on a training event or a conference event, based on the name of the company x how many of each type of event they've been to. I have uploaded an example workbook which hopefully explains it better - Upload files for free - events example dummy data.xlsx - ufile.io
Any help much appreciated!
Thanks.
I need help with a formula please.
I have an events spreadsheet:
Tab 1: A user enters event/delegate details and notes whether the event is training or a conference.
Tab 2: Financial info on how much each company has spent on tickets
Tab 3: Training and conference events have a ticket cost filled in here (to allow this to be easily amended each year).
In tab 2 I need to evaluate how much each company who sends attendees to the event has spent on a training event or a conference event, based on the name of the company x how many of each type of event they've been to. I have uploaded an example workbook which hopefully explains it better - Upload files for free - events example dummy data.xlsx - ufile.io
Any help much appreciated!
Thanks.