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
Recent Articles
Seeded Random Number Generator in Excel
How to keep random numbers from changing in Excel? Excel's random functions like RAND and RANDARRAY recalculate every time you edit your worksheet, making it impossible to maintain stable random results. This article shows you how to build a seeded random number generator using Excel's...Read more
Topics By Category
User Testimonials
Exceljet.net is a really good resource and has helped me numerous times move from a beginner Excel user to a high end intermediate user.
Isaac
I just wanted to say how much of resource you've created. With Exceljet I've been able to automate a budgeting issue which, without hyperbole, has not been done in approximately 50yrs in my niche industry. No one simply put in the time to realize it could all be 1s and 0s. And with your site, I've been able to guide myself how to do exactly that.
John
Your website saved my life! I have an ICT practical test tomorrow and I still don't understand some of the functions but your videos helped a lot! Thank you so much.
Maryam
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.
