Featured Formulas

VLOOKUP without #N/A error

When VLOOKUP can't find a value in a lookup table, it returns the #N/A error. In this example, the goal is to remove the #N/A error that VLOOKUP returns when it can't find a lookup value. In general, the best way to do this is to use the IFNA function. However, the IFERROR function can also...Read more

Featured Functions

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

Recent Articles

Thanks for your website, I find answers to most of my questions and especially your explanations are very clear! (I work in supply chain management, thanks to your website i can build and improve follow-up tables)
Edward
Out of all the Excel sites, this is by far the best. Very clean and useful tips and methods. It helped me a lot in my work.
Zoltán
I found Exceljet through a google search when I was trying to figure out the correct syntax for a formula. Of course, when you do a search in this manner, several options pop up. Well, after looking at several websites that allegedly had the answer to my question, I finally took a gander at your site. BINGO!! Exceljet had the answer because you provide very detailed explanations AND examples. My problem solved. After that experience, I always turn to Exceljet first. So far, I have not had to look any further.
Barbara

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