Home Excel Functions

Functions

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

VLOOKUP Function in Excel

0
Comprehensive VLOOKUP glossary with downloadable examples.

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

AVERAGEIF Function

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

Autosum Function

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

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

SUMIF Function

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

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

COUNTIF Function

0
The COUNTIF Function in Excel is extremely useful when dealing with large data sets. Here is a basic example of house to...

Latest Tutorials

Excel Tip Calculator

Tip Calculator Template

sum if date is greater

Sum if date is greater than

Calculate Work Days in Excel

Sum if between