Featured Formulas

Sum

Sum if case-sensitive

To calculate a case-sensitive "sum if", you can use a formula based on the EXACT function and the SUMPRODUCT function. In the example shown, the formula in F5, copied down, is: =SUMPRODUCT(--EXACT(E5,code)*qty) Where code (B5:B15) and qty (C5:C15) …Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Dynamic array

PIVOTBY Function

The Excel PIVOTBY function is designed to summarize data by grouping rows and columns. The result is a dynamic summary table created with a single formula.Read more

More Functions

Recent Articles

Formulas

Combinations and permutations in Excel

Combinations and permutations are two basic ways to count possibilities, used in probability, statistics, games, passwords, and lotteries. This article explains the difference between them, when order and repetition matter, and the Excel functions you can use to calculate each case: FACT, PERMUT, …Read more

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Very cool, Dave. Excellent post. Your (always!) clear and straightforward explanations for everything in Excel remain the best. Truly. I do legal work, not data. But I use these more complex Excel skills weekly.
Libby
Once again, I find your website the "go-to" source for clean, concise explanations of Excel functionality. A coworker sent an interesting spreadsheet with unique functions to achieve results with non-mathematical data. I had not experienced nor needed this particular sector of Excel software before, and your website made quick work of understanding those new functions and formulas. As an aerospace design engineer, I highly value organized and logically presented information. The cool general layout of the pages and pleasing aesthetics are just a bonus. Keep up the great work!
Z
I am an IT Trainer, based in London and working internationally worldwide, mostly Pharma, Banking and Law Firms. I subscribed to your newsletter and regularly visit your website. I am completely blown away by your mails and explanations. They are by far the best one can find on the web. I look forward to your weekly letter. I refer to your website every single Excel training and to every customer I have!
Avi
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