The other option is to go to the Formulas tab in the function and library group; click Math and Trig. In the drop-down menu, select SUMIF ... and Pivot Chart in Excel.

So you export the relevant data into Excel, where you use the SUMIF function [SUMIF (range ... At the end of the operation, as explained above, SUMPRODUCT sums the products of the rows and reports ...

Microsoft Office has a number of comparison operations so you can check if a value is greater than, equal to or less than another value using the standard greater than, less than and equal symbols.