Featured Formulas

Count

Count cells between dates

In this example, the goal is to count the number of cells in column D that contain dates that are between two variable dates in G4 and G5. This problem can be solved with the COUNTIFS function or the SUMPRODUCT function, as explained below. For convenience, the worksheet contains two...Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Dynamic array

VSTACK Function

The Excel VSTACK function combines arrays vertically into a single array. Each subsequent array is appended to the bottom of the previous array. The result from VSTACK is a single array that spills onto the worksheet into multiple cells....Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Excellent - Excellent - Excellent. You have such awesome tricks using Excel. I use them as a tool when I am teaching Excel to my students at a college where I teach.
Mike
I love the chatbot! What a great idea!...the answer was understandable, informative, and exactly what I needed. Much as I was originally opposed to AI, I’ve seen some pretty awesome use of it and have changed my stance substantially.
Peg
I work in the field of data migration and have recently had to work in Excel more than I had previously wanted. Using your site though, I have found that much of what I thought wasn't possible outside SQL is and that I can actually accomplish a lot of the work I need to do using Excel. Your explanations are, as you say, direct and to the point and huge thanks to you for the site.
Nigel
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