Featured Formulas

Lookup

Rank and score with INDEX and MATCH

In this example, the goal is to assign points based on a ranked score. The scores to rank are in column C, and the calculated Rank is in column D. Points are awarded based on the table in G5:H10. Both tblData (B5:E15) and tblPoints (G5:H10) are...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Math

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

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Just wanted to say thank you for your random name list formula. Your solution helped me condense several columns into 1 cell!!
Jarvis
Exceljet is my go-to place when I need a formula that I can't remember how to code. You folks have a terrific website, you examples are easy to follow, you explain what the formula is doing, and show options or alternatives. I usually use your alternatives to teach myself new ways to exploit Excel. Great job and thank you.
Steve
Just wanted to give a HUGE thank you for all of your content. I was NOT proficient at Excel, even though my resume clearly says differently ;), until I found this website. Now, I've become the "Excel Guy" at my company and I owe 90%-ish to ExcelJet. I have yet to find another website that gives clear, concise, and in-depth explanations like you do. KEEP UP THE GREAT WORK!
James
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