Featured Formulas

Count

Count cells that contain errors

In this example, the goal is to count errors in the range B5:B15, which is named data for convenience. The article below explains several different approaches, depending on your needs. For background, this article: ...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Date and time

WORKDAY Function

The WORKDAY function calculates a date that is a given number of working days from a specified start date, automatically excluding weekends and, optionally, holidays. You can use the WORKDAY function to calculate project start dates, delivery dates, due dates, and other dates that must...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

I have been using your tips for over 4 years and I have always found it to be a wealth of information. Wanted to give you guys a quick shout out. I just rediscovered the indirect function, which I vaguely remembered you had covered before. It has enabled me pull out specific items of information which resides in the same cell of many many worksheets
Paul
I just wanted to add my comment to the many many others who appreciate the clear concise and informative information here. I find these days when I'm looking for help on excel I start by searching exceljet. Great stuff I'm a fan.
Barnaby
I love learning new formulas from Exceljet. We need all these formulas for our jobs everyday. Thank you so much for helping us to learn.
Carmen
More Testimonials

Get Training

We offer free resources and paid training.

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed.

View Paid Training & Bundles

Just show me the free stuff

Excel 101 and Core Pivot Packages