SUMIF, SUMIFS, AVERAGEIFS, and COUNTIFS are commonly used accounting functions in Microsoft Excel. These formulas are used to calculate cell values based on the criteria you have described or ...

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.