Featured Formulas

Sum

Sum by year

In this example, the goal is to calculate a total for each year that appears in column F. All data is in an Excel Table called data in the range B5:D16. The main challenge is that we have dates in column B, but we don't have separate year...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Dynamic array

UNIQUE Function

The Excel UNIQUE function extracts a list of unique values from a range or array. The result is a dynamic array of unique values. If this array is the final result (i.e. not handed off to another function), array values will "spill" onto the worksheet into a...Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Amazing guide. Helpful. Thank you thank you thank you. My many students in finance all thank you.
Anisah
I'm reaching out to thank you for the hard work you have put in to helping others with Excel. I routinely use your website for work. I'd be lost without it!
Leo
It is only because of your website that I have the interest to learn how to use Excel. I can only say a huge burden was lifted off my head when I discovered your site. I used to hate Excel before. I found it complex and was disinterested too, but all that has changed now. I'm grateful.
RB
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