WRITING FORMULAS IN SMARTSHEET QUIZ WITH ACCURATE SOLUTIONS

WRITING FORMULAS IN
SMARTSHEET QUIZ WITH ACCURATE
SOLUTIONS




Kai ois obuilding oa osheet oto otrack oopportunities ofor ohis osales oteam. oFor oeach
oopportunity, othe osalesperson oenters otheir oRegion oand othe oOpportunity oValue.
oKai owants oto oknow othe ototal ovalue oof oall oopportunities oin othe oWestern oregion.
oWhich oformula oshould oKai ouse oto oadd osales oopportunities ofor othe oWestern
oregion?


=SUMIF(Region:Region, o"Western", o[Opportunity oValue]:[Opportunity oValue])
=COUNTIF([Opportunity oValue]:[Opportunity oValue], oRegion:Region, o"Western")
=SUMIF([Opportunity oValue]:[Opportunity oValue], oRegion:Region, o"Western")
=COUNTIF(Region:Region, o"Western", o[Opportunity oValue]:[Opportunity oValue]) o-
ocorrect oanswers o-=SUMIF(Region:Region, o"Western", o[Opportunity oValue]:
[Opportunity oValue])