Formulas -> Function Library->Math and Trig -> SUMIFS

### SUMIFS Function

What is
the SUM of the products with more than $300.00 in sales each day?

**SUMIFS**
lets you use several **Criteria** in the formula. This function works with the numbers, not the text.

**1. Try
This:
SUMIFS**

Select Cell D72.

Type: SUMIFS All Sales Greater than $300. Format the
Cell to Wrap Text.

Select Cell E72.

Go to **Formulas -> Function Library. **

Go to **Math and Trig->SUMIFS**.

Enter the **Sum_Range**: Revenue

Enter the Criteria_range1: Revenue

Enter
Criteria1: >300.

Click OK.

**2. What
Do You See? **The formula is;

=SUMIFS(Revenue,Revenue,">300")

Keep
going...