## How to Use the SUMIF Function

The Sum formula is one of the most common formulas that you’ll use in Excel. This formula allows you to add up the

27 Sep

## RANDBETWEEN – Excel Function

What it does: The RANDBETWEEN() Function generates a random number between two integers. Plain English: Rather than

## RAND – Excel Function

What it does: The RAND() Function generates a random number between 0 and 1. Plain English: The random function is a brother

## AVERAGE – Excel Function

The Average function only takes numbers as arguments, and calculates the arithmetic average of the data. These numbers can be

## SMALL – Excel Function

What it does: The SMALL() Function provides the n-th smallest piece of data from an array. Plain English: The SMALL()

## LARGE – Excel Function

What it does: The LARGE() Function provides the n-th largest piece of data from an array. Plain English: The LARGE() Function

## COUNTIFS – Excel Function

What it does: The COUNTIFS() Function allows you to count the number of cells that match multiple criteria. Plain English:

## How to Use Excel’s COUNT Functions

There are many functions in Excel that contain “count” in the name. What are the differences? In this blog post

27 Sep

## SUMIF – Excel Function

What it does: The SUMIF() Functions sum together values based on criteria you provide. Plain English: The SUMIF() formula is