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

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

SUMIF – Excel Function

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