Featured Formulas

Workbook

Count errors in all sheets

To count errors by sheet a workbook you can use a formula based on the ISERROR function, with help from INDIRECT and SUMPRODUCT. In the worksheet shown, the formula in cell C5 is: =SUMPRODUCT(--(ISERROR(INDIRECT("'"&B5&"'!A1:F101")))) As the formula …Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Date and time

EDATE Function

The Excel EDATE function adds and subtracts complete months from a given date. You can use EDATE to calculate expiration dates, maturity dates, and other due dates derived from a start date.Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

I just wanted to tell you that your site is excellent. I have found so many examples and a great help in my job. Your examples for sumproduct and multiple criteria, index and match with multiple criteria are unbelievable. Congratulations!
Nick
I've used your website as a reference for excel help for a couple years now and I just wanted to take a minute to thank you for all the content available on your website. I am now the excel "guru" at my company but in reality I'm just a hack who knows how to search the info you've made available.
Chris
I do really appreciate the work you have done. It is a cut above everything else out there.
Doug
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