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 C:C contains sales values and range A:A locations Boston New York City, London, What would be an appropriate formula to calculate the total sales for all orders originating from Boston
a COUNTIFC:C A:A "Boston"
b SUMIFSC:C A:A "Boston"
c SUMIFC:C A:A "Boston"
d COUNTIFSC:C A:A "Boston"
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
