Featured Formulas

Maximum change

In the example shown, the goal is to calculate the maximum difference between the "High" values in column C and the "Low" values in column D. Because the difference between High and Low is not part of the data, the calculation must occur in the formula itself. This is a classic example of an...Read more

Featured Functions

COUNTIFS Function

The COUNTIFS function counts cells in a range when they meet one or more specific conditions. COUNTIFS is one of Excel's most widely used functions, and you find it in all kinds of spreadsheets that perform conditional counts based on dates, text, or numbers. Although common, COUNTIFS has a...Read more

Recent Articles

Just a really quick note to say thanks for the "normalize size units to gigabytes" formula -- it's one of the very few times in my 25+ year career that I've found a help page on the net where the suggested solution worked perfectly, unmodified.
Ian
I want to thank you for all of the assistance that you have given me in the past, I truly appreciate it. I inform everyone at my place of work about your website, as I find it perhaps one of the best to understand.
Shane
I'd like to just say many thanks to you for the great resource you created! It helps me a lot to get new Excel skills and keep my brain working. I've been using Exceljet since 2017 and very glad that it is up-to-date with new versions of Excel. Thank you!
Artem

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