I have a table of Recipe Ingredients with columns (Recipe, Ingredient, Amount). I want to create a Shopping List table so that when a User picks out Recipes, it aggregates and sums the Amount by Ingredient. For example: [image]

Hey @Jennifer_Lastimosa , here is an example how to do that: The main formula in the ‘total column’ is: =Recipes.Filter(Ingredients=thisRow.Name).Amount.sum() This will search your Recipe table by all occurings of the Ingredient in the current row gets the amount of it sums all the amounts An…

Aggregate Table

Jennifer_Lastimosa August 14, 2019, 1:06am 3

Sorry for the late response, but thank you so much for this!

1 Like

Topic		Replies	Views
Why is my formula not filtering out multiple conditions?	2	416	August 22, 2022
Filter on the Sum of a Group	4	478	November 27, 2022
Trouble with lists	2	343	January 7, 2022
Button - Filtering for Sums Between Tables [Formula Help]	8	793	October 3, 2019
Sum from a Select List objects	6	499	September 3, 2021

Aggregate Table

Related Topics