Question: Range C 2 :C 2 0 0 contains sales values and range A 2 :A 2 0 0 locations ( Boston , New York City,

Range C2:C200 contains sales values and range A2:A200 locations (Boston, New York City, London, ...). What would be an appropriate formula to calculate the total sales for all orders originating from Boston
a)= COUNTIF(C2:C200, A2:A200, "Boston")
b)= SUMIFS(C2:C200, A2:A200, "Boston")
c)= SUMIF(C2:C200, A2:A200, "Boston")
d)= COUNTIFS(C2:C200, A2:A200, "Boston")
 Range C2:C200 contains sales values and range A2:A200 locations (Boston, New

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!