Featured Formulas

Count

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

More Formulas

Featured Videos

More Videos

Featured Functions

Date and time

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

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

Just signed up. Very, very impressed with your site. Looking forward to using so many of your great resources. PLEASE keep up the great work!
Troy
I would like to thank you for this excellent website. It helped me a lot with my work, and it is my first reference when looking for help in Excel.
Sami
Your website is an absolute gem! I recently had to learn Excel after using statistical software. I even recruited my husband to help me find some ADHD-friendly Excel tutorials and all we found was a bunch of fluff. I stumbled on exceljet and after one tutorial was sold; for the first time I didn't feel more annoyed than informed at the end of a tutorial. Everything is logically organized on here and the instructions are thorough without any bull.
Ruby
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