Formulas -> Function Library->Math and Trig -> SUMIFS
the SUM of the products with more than $300.00 in sales each day?
lets you use several Criteria in the formula. This function works with the numbers, not the text.
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
Do You See? The formula is;