Featured Formulas

Count rows that contain specific values

In this example, the goal is to count the number of rows in the data that contain the value in cell G4, which is 19. The main challenge in this problem is that the value might appear in any column, and might appear more than once in the same row. If we wanted to simply count the total...Read more

Featured Functions

DATEDIF Function

The DATEDIF function is designed to calculate the difference between two date values in years, months, or days. The result from DATEDIF is a number that corresponds to the time unit requested. DATEDIF is a versatile function that can be used in financial analysis, project planning, age...Read more

Recent Articles

Since I started working 6 months ago, I've been using Excel extensively. And I cannot put in words how grateful I am. You've been helping me alot with your blog posts! Thanks!
Fabricio
This is my go-to website for excel you have helped me out many times. Thanks so much to your clarity and transparency and integrity in all you do.
Jennifer
You product is phenomenal! Easy to understand and gets to the meat of the function quickly.
Jennifer

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