Sums and subtotals
housecd
Posted messages
3
Registration date
Status
Membre
Last intervention
-
housecd Posted messages 3 Registration date Status Membre Last intervention -
housecd Posted messages 3 Registration date Status Membre Last intervention -
Hello everyone,
Well, here's the thing, I’m working on Excel (2013) to organize an event, specifically a wedding.
Here’s an image of a sample spreadsheet I created:
On the table (tab called: "Addresses"), to clarify:
- I’ve grouped different people with their addresses, whether they are invited to the cocktail and/or dinner and/or evening and/or brunch (for the last one, it corresponds to the meal the next day if you want to know everything);
- If it’s Mr. and Mrs., regardless of C/D/S or B, I count 2 people
- If it’s Mr. (or Mrs.), I count 1
- To differentiate who invites which people, I added in the first column the name of the person inviting.
Once the table is complete, I would like to create a summary of the guests in another tab called "Number of Guests", based on who invites, at what time, as indicated in the following image:
And now, I’m having trouble figuring out which formula/combinations of formulas to use to get the desired result.
Can someone please clarify my question?
I remain at your disposal for any further information
Thank you for your kindness
Well, here's the thing, I’m working on Excel (2013) to organize an event, specifically a wedding.
Here’s an image of a sample spreadsheet I created:
On the table (tab called: "Addresses"), to clarify:
- I’ve grouped different people with their addresses, whether they are invited to the cocktail and/or dinner and/or evening and/or brunch (for the last one, it corresponds to the meal the next day if you want to know everything);
- If it’s Mr. and Mrs., regardless of C/D/S or B, I count 2 people
- If it’s Mr. (or Mrs.), I count 1
- To differentiate who invites which people, I added in the first column the name of the person inviting.
Once the table is complete, I would like to create a summary of the guests in another tab called "Number of Guests", based on who invites, at what time, as indicated in the following image:
And now, I’m having trouble figuring out which formula/combinations of formulas to use to get the desired result.
Can someone please clarify my question?
I remain at your disposal for any further information
Thank you for your kindness
1 réponse
Hello
Your table is perfect for creating a Pivot Table and it will be the easiest
- Select the entire range, including column headers,
- Insert tab, Pivot Table, to be placed on another sheet then OK
And you drag the invitees to the row labels and the types of invitations to values
--
Argitxu
Your table is perfect for creating a Pivot Table and it will be the easiest
- Select the entire range, including column headers,
- Insert tab, Pivot Table, to be placed on another sheet then OK
And you drag the invitees to the row labels and the types of invitations to values
--
Argitxu
housecd
Posted messages
3
Registration date
Status
Membre
Last intervention
Thank you argixu for your help! I had completely forgotten about the pivot tables!!