Featured Formulas

XLOOKUP with multiple criteria

In this example, the goal is to look up a price using XLOOKUP with multiple criteria. To be more specific, we want to look up a price based on Item, Size, and Color. At a glance, this seems like a difficult problem because XLOOKUP only has one value for lookup_value and lookup_array...Read more

Featured Functions

SUMIFS Function

The SUMIFS function sums numbers in Excel when they meet one or more specific conditions. SUMIFS is one of Excel's most widely used functions, and you will see it in all kinds of spreadsheets that calculate conditional sums based on dates, text, or numbers. Although a common function, ...Read more

Recent Articles

I work in the field of data migration and have recently had to work in Excel more than I had previously wanted. Using your site though, I have found that much of what I thought wasn't possible outside SQL is and that I can actually accomplish a lot of the work I need to do using Excel. Your explanations are, as you say, direct and to the point and huge thanks to you for the site.
Nigel
This is a great web site. Have been using it for a while and getting your Friday email. I learn something new every time I get the email or visit your site.
George
Works like a dream! Thanks very much Dave Very helpful :)
Rhiannon

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