Featured Formulas

Sum

Sum by weekday

To sum values by day of week, you can use the SUMPRODUCT function together with the TEXT function. In the example shown, the formula in F5 is: =SUMPRODUCT((TEXT(data[Date],"ddd")=E5)*(data[Amount])) where data is an Excel Table in the range B5:C16. …Read more

More Formulas

Featured Videos

More Videos

Featured Functions

Text

SEARCH Function

The Excel SEARCH function returns the location of one text string inside another. SEARCH returns the position of find_text inside within_text as a number. SEARCH supports wildcards, and is not case-sensitive.Read more

More Functions

Recent Articles

More Articles

Topics By Category

Formulas

Shortcuts

Functions

User Testimonials

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
I just wanted to say that I love your newsletter I am constantly learning new cool tricks that make my work easier and make me look like a Jedi at work. Keep it coming!
Rafael
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