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 | Vegetarian | 3 | ||||
16 | ||||||
17 | ||||||
18 | Result | Formula | ||||
19 | 1 | =DCOUNTA($A$2:$E$10,B2,$A$14:$E$15) | ||||
20 | 1 | =DCOUNTA($A$2:$E$10,"Recipe",$A$14:$E$15) | ||||
21 | 1 | =DCOUNTA($A$2:$E$10,2,$A$14:$E$15) | ||||
22 | 1 | =DCOUNTA('General Usage'!$A$2:$E$10,B2,$A$14:$E$15) | ||||
23 | ||||||
24 | ||||||
25 | Comparison | Formula | ||||
26 | 1 | =DCOUNTA($A$2:$E$10,"Recipe",$A$14:$E$15) | ||||
27 | 0 | =DCOUNT($A$2:$E$10,"Recipe",$A$14:$E$15) | ||||
28 |
1 | Criteria_arr | ||||||
---|---|---|---|---|---|---|---|
2 | Key | Recipe | Category | Preparation | Preparation | Calories | |
3 | Vegetarian | >=3 | <10 | ||||
4 | |||||||
5 | |||||||
6 | Result | Formula | |||||
7 | 2 | =DCOUNTA('General Usage'!$A$2:$E$10,B2,$A$2:$F$3) | |||||
8 |