Cookie Name Country Cookies Sold
Chocolate Chip United States 28 Sumif 52.66667 =AVERAGEIF(A:A,A2,C:C)
Oatmeal Raisin United States 32 * 802 =SUMIF(B:B,"*s",C:C)
Sugar Cookie United States 52 ? 0 =SUMIF(B:B,"?s",C:C)
Snickerdoodle United States 67 sumifs single
Birthday Cake United States 44
Peanut Butter United States 39 sumifs multiple columns
Fortune United States 100
Chocolate Chip India 75 sumifs multiple rows
Oatmeal Raisin India 32
Sugar Cookie India 40
Snickerdoodle India 21 Averageif 43
Birthday Cake India 58 Averageifs
Peanut Butter India 21 Countif
Fortune India 54 Countifs
Chocolate Chip Philippines 55 Minifs
Oatmeal Raisin Philippines 41 Maxifs
Sugar Cookie Philippines 92
Snickerdoodle Philippines 89
Birthday Cake Philippines 34
Peanut Butter Philippines 29
Fortune Philippines 100
EIF(A:A,A2,C:C)
:B,"*s",C:C)
:B,"?s",C:C)
Cookie Name Country Cookies Sold
Chocolate Chip United States 28 Sumif 158 =SUMIF(A:A,"Chocolate Chip",C:C)
Oatmeal Raisin United States 32 * 802 =SUMIF(B:B,"*s",C:C)
Sugar Cookie United States 52 ?
Snickerdoodle United States 67 sumifs single 158 =SUMIFS(C:C,A:A,"Chocolate Chip")
Birthday Cake United States 44
Peanut Butter United States 39 sumifs multiple columns 28 =SUMIFS(C:C,B:B,B2,A:A,A2)
Fortune United States 100
Chocolate Chip India 75 sumifs multiple rows 60 {=SUM(SUMIFS(C:C,B:B,B2,A:A,A2:A
Oatmeal Raisin India 32 124
Sugar Cookie India 40 Chocolate Chip
Snickerdoodle India 21 Averageif Sugar Cookie
Birthday Cake India 58 Averageifs Birthday Cake
Peanut Butter India 21 Countif
Fortune India 54 Countifs
Chocolate Chip Philippines 55 Minifs
Oatmeal Raisin Philippines 41 Maxifs
Sugar Cookie Philippines 92
Snickerdoodle Philippines 89
Birthday Cake Philippines 34
Peanut Butter Philippines 29
Fortune Philippines 100
:A,"Chocolate Chip",C:C)
:B,"*s",C:C)
C:C,A:A,"Chocolate Chip")
C:C,B:B,B2,A:A,A2)
UMIFS(C:C,B:B,B2,A:A,A2:A3))}
Chocolate Chip
Sugar Cookie
Birthday Cake
