## COUNTIFS – Excel Function

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

## Using AUTOFILL in Excel – Part 2

(click here for Part 1) Paste Formulas Another way that you can autofill a formula across multiple cells is to Paste

## Using AUTOFILL in Excel – Part 1

The Autofill button is one of the simplest, yet greatest tools in Excel. There are a variety of different ways to use the

## Using IFERROR to trap and handle errors

When I first found out about IFERROR, I was a little confused. “There’s a formula to use if we generate an error?

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

## Manipulating Text in Excel – LEN, RIGHT, LEFT, & MID

There are many times in Excel when you only need to extrapolate or evaluate PART of a cell. For this, the following functions

## The IF Function in Excel & Boolean Logic

If new to Excel and building formulas, there’s a concept I think is very important to understand before learning to