Functions

Learn predefined excel functions used to calculate specific values. Excelbuddy covers dozens of functions with easy to follow demonstrations.

SUMIF Function

The SUMIF function in Excel sums up particular cells based upon certain criteria. Criteria is specified using logical operators. Common operators...

If Function

The IF Function in excel is a logical test that can be run using specific conditions. This logical test returns one value...

AverageIFS Function

Finding the arithmetic mean in Excel is very easy.  In this example, we will be using the AVERAGEIFS function. We will be finding...

AVERAGEIF Function

AVERAGEIF (Arithmetic Mean) – Single Criteria IF statementUse the AVERAGEIF Function to find the arithmetic mean in Excel while...

Average Function

AVERAGE (Arithmetic Mean)Finding the arithmetic mean in Excel is very easy. Just like in basic math, you add up a list of numbers and...

Autosum Function

Autosum Function Overview The AutoSum Function is by far one of the most useful features in all of Excel. Just about...

Latest Tutorials