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 have been on your emailing list and your tips have made sense to me so I thought that would take the next step and really try and up skill myself with excel.
Maara
You are fabulous!!! It worked perfectly! Thanks a million :) :)
Gloria
As a CPA and a federal & state tax preparer, I have utilized Excel for at least the last three decades. During the last few years I have come to the realization that the biggest problem I had during most of these years was not having access to Exceljet. Your excel articles and function & format analysis would have saved me time and gray hairs. For the past few years they have been a true godsend – I thank you, my Partners thank you, and several of my clients thank you.
George

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