Featured Formulas

Count between dates by age range

The goal of this example is to count rows in the data where the date joined falls between start and end dates (inclusive) and the age also falls into the age ranges seen in column G. The formula is complicated somewhat by the fact that the age range labels are actually text, so we need to...Read more

Featured Functions

TEXTSPLIT Function

The TEXTSPLIT function splits text by a given delimiter into multiple cells. TEXTSPLIT can split text into rows or columns. The output from TEXTSPLIT is an array that will spill into multiple cells on the workbook.

TEXTSPLIT...Read more

Recent Articles

Why SUMPRODUCT?

In this article, I attempt to explain why you see SUMPRODUCT so often in formulas, and when you can use the SUM function instead. The short version: SUMPRODUCT supports array operations natively, which makes it very useful for solving seemingly unrelated...Read more

As an undergrad doing radiation materials damage research, I have a lot of data to sift through and analyze. Microsoft's Excel has been a very useful multi-tool, and ExcelJet has been a extremely handy guidebook to using Excel effectively. Thank You!
Zachary
...I love your training videos. You have some great examples of different ideas and they are very easy to understand.
Douglas
I've been using your site for a while to figure out functions that I am not familiar with. The way that you guys explain things is super helpful.
Gee

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