Featured Formulas

Running total in Table

At the core, this formula has a simple pattern like this:

=SUM(first:current)

Where "first" is the first cell in the Total column, and "current" is a reference to a cell in the current row of the Total column.

To get the a...Read more

Featured Functions

VSTACK Function

The Excel VSTACK function combines arrays vertically into a single array. Each subsequent array is appended to the bottom of the previous array. The result from VSTACK is a single array that spills onto the worksheet into multiple cells....Read more

Recent Articles

I would like to say thanks millions for your superb help on xlookup. I knew I was on the right path but didn't know that you could concatenate as you had it. It was driving me nuts!!!
Paula
I've used your website as a reference for excel help for a couple years now and I just wanted to take a minute to thank you for all the content available on your website. I am now the excel "guru" at my company but in reality I'm just a hack who knows how to search the info you've made available.
Chris
I just wanted to say thanks for your awesome Excel resource. I am constantly googling for how to do random tasks in Excel and Exceljet is consistently the best resource. I impress people at work with my amazing Excel skills, but mostly I just know how to find what I need at ExcelJet!!
Laura

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