Forum Discussion

Copper Contributor

Feb 16, 2023

Solved

VLOOKUP with SUM function

Hi, I would like to use vertical search in combination with the sum function in multiple tabs. The goal is that I can see exactly how many people have eaten in the green tab. Example: T...

excel

Formulas and Functions

Riny_van_Eekelen
Feb 16, 2023
FreddyJayNL I responded to your PM. Consider to post your file and my answer (be it in Dutch) here for others to see. Or not. That's up to you.

Edit: The accepted solution is to use Power Query to connect to all individual tables, combine them and then Group and Sum by ID for all relevant columns.

FreddyJayNL

Copper Contributor

Feb 16, 2023

Riny_van_Eekelen

There are IDs who have eaten breakfast/lunch/dinner on several days.
I would like to have a formula search for ID and add together what that ID has consumed.

An example:
ID : WX1109076
19-12-2022 and 22-12-2022 : Dinner
19-12-2022 and 21-12-2022: Lunch

I want on the result sheet:

ID	Ontbijt	Lunch	Diner	Totaal
WX1109076	0	2	2	4

Riny_van_Eekelen

Platinum Contributor

Feb 16, 2023

FreddyJayNL I responded to your PM. Consider to post your file and my answer (be it in Dutch) here for others to see. Or not. That's up to you.

Edit: The accepted solution is to use Power Query to connect to all individual tables, combine them and then Group and Sum by ID for all relevant columns.