## DATEVALUE Function

The Excel DATEVALUE function is used to convert a date in Excel to text. =DATEVALUE (date_text) date_text – Date in text format. In the example below, we convert …

Skip to content
# Functions

## DATEVALUE Function

## COUNTIF Function

## PMT Function

## SUMIFS Function

## SUMIF Function

## If Function

## AverageIFS Function

## AVERAGEIF Function

## Average Function

## Autosum Function

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

The Excel DATEVALUE function is used to convert a date in Excel to text. =DATEVALUE (date_text) date_text – Date in text format. In the example below, we convert …

The COUNTIF Function in Excel is extremely useful when dealing with large data sets. Here is a basic example of house to use this function. Below we are …

The PMT function in Excel calculates the payment for a loan that has constant payments and a constant interest rate. This formula will not work with a flexible …

The SUMIFS function in Excel sums up particular cells based upon multiple criteria. The Sumif Function is only able to use one criteria. Criteria is specified using logical …

The SUMIF function in Excel sums up particular cells based upon certain criteria. Criteria is specified using logical operators. Common operators are >,<,<>, and =. Wildcard operators can …

The IF Function in excel is a logical test that can be run using specific conditions. This logical test returns one value for “True” and another for “False”. …

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

AVERAGEIF (Arithmetic Mean) – Single Criteria IF statement Use the AVERAGEIF Function to find the arithmetic mean in Excel while defining a specific criteria. In this example, we …

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 divide by sum …

Autosum Function Overview The AutoSum Function is by far one of the most useful features in all of Excel. Just about every spreadsheet can benefit from incorporating the …