Featured Formulas

Dynamic array

Detailed LET function example

In this example, we have a simple set of data in B5:D16 that includes ID, Name, and Points. The goal is to generate a custom message for any name in the list by entering a valid ID in cell G5. The message uses the name from column C and the points in column D like this:

...Read more
More Formulas

Featured Videos

More Videos

Featured Functions

Math

SUMPRODUCT Function

The SUMPRODUCT function multiplies arrays together and returns the sum of products. If only one array is supplied, SUMPRODUCT will simply sum the items in the array. Up to 30 ranges or arrays can be supplied. When you first encounter...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

These tutorials are fantastic. People like me learn faster by following along with the steps in the video.
Tim
ExcelJet has been awesome for me in terms of learning new functions, refreshing myself on old functions I may have forgotten how to use, and I love how you break down how something works into multiple steps.
Cal
Excellent tutorial, saved me hours of work, well done.
Mark Bridgeman
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