Featured Formulas

Count cells that begin with

In this example, the goal is to count cells in the range B5:B16 that begin with specific text, which is provided in column D. For convenience, the range B5:B16 is named data

COUNTIF function

The simplest way to solve this problem is with the ...Read more

Featured Functions

EDATE Function

The EDATE function returns a date on the same day of the month, n months before or after a start date. You can use EDATE to generate expiration dates, contract dates, due dates, anniversary dates, retirement dates, and other dates that derive from a start date. EDATE returns a...Read more

Recent Articles

New Excel Functions

Nearly 50 new functions have been added to Excel! This is not your Dad's Excel anymore – a lot has changed. This article takes a quick tour of the new functions, with links to more detailed information....Read more

I love that you send only 1 tip per week, an overload of emails just makes you ignore them until you unsubscribe, since I can handle 1 email per week, I actually read them and often they contain something new I didn't know yet.
Stijn
I was looking for a way to make SUMPRODUCT conditional, if possible, and your page https://exceljet.net/formula/sumproduct-with-if came up at the top of my Google search. I would like to say that this solution is absolutely genius - it works a treat! It is so easy to implement too.
Adam
I watched a few videos this morning and learned one key thing that will save me hours at work!
Janice

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