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
HYPERLINK Function
The HYPERLINK function creates a hyperlink to a given destination with a "friendly name", which is simply the anchor text. You can use HYPERLINK to construct a clickable hyperlink with a formula. The HYPERLINK function can build links to other cells in a workbook, other sheets, named...Read more
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
I've taken a couple of your courses and absolutely love your teaching format!
Barbara
I just wanted to say a huge THANK YOU to you both for your amazing content. I have been using your site for about 6 months now and you have always had the information I was looking for. I have been able to up my game in Excel and am creating more meaningful reports thanks to you. You are making my work life so much easier!
Duane
Your YouTube videos ROCK!! Thanks for producing them with such quality and brevity.
Mike
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.
