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

This is the MOST helpful, insightful excel site I have ever come across!! Every example is in plain English. You guys have me looking like a GENIUS at work. Thank you Thank you!
Adam
Your newsletter examples and website info have consistently remained the most helpful resource for me in my new job.
Kim
Your site is the best Excel resource, period. I first discovered you when I googled pivot tables and read "Can Pivot Tables Save Your Job". That article is so true! I've since developed expertise in regular Tables and made a workflow management tool for my job, which in turn has made me the only person in a collaborative of hospitals to be complete and on-time with data delivery. Because of this, I have proven value and credibility, and owe it all to developing my skills with your site.
Fred
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