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
RANK Function
The RANK function returns the rank of a numeric value compared to a list of other numeric values. RANK can rank values from largest to smallest (i.e., the rank of highest test scores) and smallest to largest (i.e., the rank of fastest times in a race). You can use the RANK function to...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
Just wanted to send a quick thank you for this website and all of the work you've put into it. Over the past year, I've been on a mission to improve my Excel game and your website has been my primary resource. It's super friendly and breaks things down in a way that's quick to put to use. We use Excel to manage large amounts of data at work and I've been able to implement some changes to our processes that are saving loads of time. In large part because of that, I was recently promoted to #2 in my department.
Mike
Thank you! I got it working. Your site and advice is fantastic!
Holly
Since I started working 6 months ago, I've been using Excel extensively. And I cannot put in words how grateful I am. You've been helping me alot with your blog posts! Thanks!
Fabricio
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.
