1 | Database_arr | |||||
|---|---|---|---|---|---|---|
2 | Key | Recipe | Category | Preparation | Calories | |
3 | 1 | Caprese Salad | Vegetarian | 5 | 200 | |
4 | 2 | Burrito Eroica | Epicurean | 10 | 1900 | |
5 | 3 | Celery Rawshticks | Vegan | 3 | 100 | |
6 | 4 | Linguine al Pesto | Vegetarian | 15 | 400 | |
7 | 5 | Swiss-Mushroom Burger | Epicurean | 14 | 700 | |
8 | 6 | Nutella Sandwich | Vegetarian | 3 | 440 | |
9 | 7 | Paella Valenciana | Epicurean | 40 | 650 | |
10 | 8 | Risotto Milanese | Vegetarian | 30 | 600 | |
11 | ||||||
12 | ||||||
13 | Criteria_arr | |||||
14 | Key | Recipe | Category | Preparation | Calories | |
15 | Epicurean | |||||
16 | ||||||
17 | Result | Formula | ||||
18 | 5600 | =DPRODUCT($A$2:$E$10, "Preparation",$A$14:$E$15) | ||||
19 | 5600 | =DPRODUCT($A$2:$E$10,D2,$A$14:$E$15) | ||||
20 | 5600 | =DPRODUCT($A$2:$E$10,4,$A$14:$E$15) | ||||
21 | 5600 | =DPRODUCT('General Usage'!$A$2:$E$10, "Preparation",$A$14:$E$15) | ||||
22 | ||||||
1 | Criteria_arr | ||||||
|---|---|---|---|---|---|---|---|
2 | Key | Recipe | Category | Preparation | Calories | Calories | |
3 | >=50 | <=400 | |||||
4 | |||||||
5 | |||||||
6 | Result | Formula | |||||
7 | 225 | =DPRODUCT('General Usage'!$A$2:$E$10, "Preparation", $A$2:$F$3) | |||||
8 | |||||||