DAVERAGE - Google Drive

DAVERAGE


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		<500
16
17
18	Result	Formula
19	7.666666667	=DAVERAGE($A$2:$E$10,D2,$A$14:$E$15)
20	7.666666667	=DAVERAGE($A$2:$E$10,"Preparation",$A$14:$E$15)
21	7.666666667	=DAVERAGE($A$2:$E$10,4,$A$14:$E$15)
22	7.666666667	=DAVERAGE('General Usage'!$A$2:$E$10,D2,$A$14:$E$15)
23

Published by Google Sheets–Report Abuse–Updated automatically every 5 minutes