Featured Formulas

Count

Count total matches in two ranges

To count total matches in two ranges, you can use a formula that combines the COUNTIF function with the SUMPRODUCT function. In the example shown, the formula in cell F5 is: =SUMPRODUCT(COUNTIF(range1,range2)) where range1 (B5:B16) and range2 …Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Statistical

RANK Function

The Excel RANK function returns the rank of a numeric value when compared to a list of other numeric values. RANK can rank values from largest to smallest (i.e. top sales) as well as smallest to largest (i.e. fastest time).Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

One of the Best websites I have visited. Every topic on the site is useful, helpful, clear. I have included it in my favorite list to visit every time I need help or a guide in excel.
Khaled
Thank you for the great videos. In my office I use Excel all the time and thanks in part to you I am getting to be a real pro. A year and a half ago I had zero experience with spreadsheets and now people in my office come to me with their Excel issues!
Nathan
I have used vlookup a lot and read some about index and match, but decided to add extra columns and stay with vlookup, however, your site was so very clear that making the switch (only where necessary) was very easy. For the first time, I understand index and match match. Thank you.
Garth
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