This is a Microsoft Excel problem: You own several convenience stores in several cities. You have a spreadsheet that contains sales data for all...

This is a Microsoft Excel problem:

You own several convenience stores in several cities. You have a spreadsheet that contains sales data for all products sold at the stores. You want to calculate the sum of the "sales of coffee" in your stores "in Chicago". 

Describe 2 different (SUM-related) functions for this scenario.

(hint: 1- Both of these (SUM-related) functions need to be able to place in a formula within a cell.

2- One of the functions should be able to use the "criteria range".

3- SubTotal tools won't work in this case)