### SUMIFS Function

What is
the SUM of the products with more than $500.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 D60.

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

Select Cell E60.

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

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

Enter the **Sum_Range**: Revenue

Enter the Criteria_range1: Revenue

Enter
Criteria1: >500.

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

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

Keep
going....