Featured Formulas

Count cells that contain n characters

In this example, the goal is to count the number of cells in B5:B15 that contain a given number of characters, where the number of characters n is provided as a variable in cell E4. 

SUMPRODUCT with LEN

One way to solve this problem is to use the ...Read more

Featured Functions

NETWORKDAYS Function

The NETWORKDAYS function returns the number of working days between two dates, automatically excluding weekends (Saturday and Sunday) and optionally excluding holidays provided as a list of dates. NETWORKDAYS can be used to calculate employee benefits that accrue...Read more

Recent Articles

I work as a Financial Controller and I do all kinds of calculations, reports, etc. and I try to be as efficient (and clever) as possible using various formulas and Excel tricks. When I have some issue in Excel almost every time I find solutions on your web pages. The explanations of various topics are great and understandable at first glance.
Zdeněk
I just wanted to let you know that I think your training resources are amazing. Heartfelt thanks!
Alison
I wanted to reach out to let you know what a fantastic resource this site has been for me over the years. I find myself back here every time I am certain Excel *can* do something, I just don't know *how*. You also seem to have an uncanny knack for sending newsletters that highlight the perfect solution for my latest Excel challenge! My colleagues think I am some sort of Excel wizard, but I tell them I just have a really good resource (and yes, I share it with them!)
Christy

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