Featured Formulas

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

Featured Functions

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

Recent Articles

I now work for a homeless charity and wanted to be able to see how many rooms we have free in the hostel at any given time without manually counting them each time. I knew there would be a way to do it but didn't know how! I spent only a couple of minutes on your site and found the answer: I needed "countif" instead of "count" which I'd been trying and it worked straight away once I got my brackets in the right place!!
Annette
Dave, you are an excellent teacher. I've learned so much from your videos (I'm a visual learner), and I appreciate that you provide the text/script for learners who learn best by reading. Your instructions are "pithy"/concise and the length of each video is about all I can absorb at one sitting (depending on the complexity)
Carol
OMG!!! Thank you soooo much - I wear out my select-fill down menu + short cut keys - this tip is ABSOLUTELY WONDERFUL!
Sylvia

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