Another great way that you can use the SUMPRODUCT function is to create a conditional sum criteria.
For example, you may want to find out how much sales were made above the $3,000 transactional level. See how easy it is with this quick SUMPRODUCT example.