Add to Chrome
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
The formula =SUMIF(C2:C12; “=Paris”; D2:D12) means:
The sum of all values in D2:D12 where C2:C12 is not equal to “Paris”
The sum of all values in C2:C12 where the corresponding value in D2:D12 is equal to “Paris”
The sum of all values in D2:D12 where the corresponding value in C2:C12 is equal to “Paris”
The count of all values in D2:D12 where C2:C12 is “Paris”
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!