Here is a list of most frequently used mathematical formulas in excel. Functions are used to create formulas. Mathematical functions are used for performing arithmetic calculations.
Excel 2016 offers a plethora of mathematical functions that you can use.
Alternatively we can apply the condition to one range and sum the corresponding values in a separate column. These functions are Built-In functions. 1 a range of values and 2 a condition. Worksheet functions are categorized by their functionality.