Home Excel Functions

# Functions

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

0

### AVERAGEIF Function

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

### AverageIFS Function

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

### Average Function

0
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...

### SUMIF Function

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

### Using INDEX and Match Functions Together

0
Using INDEX and Match Functions together – Alternative to VLOOKUP Before reading this tutorial, please make sure you understand...

### Autosum Function

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

### PMT Function

0
The PMT function in Excel calculates the payment for a loan that has constant payments and a constant interest rate. This formula...

### If Function

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

### SUMIFS Function

0
The SUMIFS function in Excel sums up particular cells based upon multiple criteria. The Sumif Function is only able to use...