Sum if case-sensitive
In this example, the goal is to sum the quantities in column C by the codes in column E in a case-sensitive manner. The SUMIF function and the SUMIFS function are both good options for counting text values, and...Read more
Learn Excel with clear examples and bite-sized videos.
Featured Functions
TRIM Function
The TRIM function strips extra spaces from text, leaving only a single space between words, and removing any leading or trailing space. For example:
=TRIM(" A stitch in time. ") // returns "A stitch in time."
The TRIM function can...Read more
Recent Articles
Native checkboxes in Excel
If you've ever tried to create a to-do list, survey, or any kind of checklist in Excel, you've probably wished for a simple checkbox feature. Well, your wish has finally come true. Microsoft has finally introduced a native checkbox feature in Excel. It's easy to use
...Read more
Topics By Category
User Testimonials
Have used your site for years to get great Excel tips. I appreciate their clarity and coverage of syntax past the most basic structures. Unknown to me, I had a 'free' parenthesis in a very long nested IF statement and was having trouble tracking it down. I read through your 19 Tips for Nested IF Formulas and while I knew many of them, the tips on IFS statements, using the Alt-Enter for structuring the logic and F9 where really what I needed.
Hal
You are the best! Exceljet is my first stop to find quick specific answers to my excel questions and get my spreadsheets back up and running! Thank you!
Marisa
Thank you! I got it working. Your site and advice is fantastic!
Holly
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.
