Hi - Dave here.
Happy Friday!
How can you do a case-sensitive sum with SUMIFS?
Unfortunately, you can't.
The SUMIFS function doesn't offer a way to check case.
However, you
can create a formula to perform a case-sensitive sum. The trick is to use the EXACT function, as seen in the worksheet below:
[
download the workbook and read the full explanation]
Tip: when you see the EXACT function in a formula, you can be sure you're looking at a formula designed to be case-sensitive. The article above explains the formula in detail. Download the worksheet and see how it works.
Holiday sale!
Save 25% on any course or bundle. Here's what you get:
- Bite-sized videos - one topic in 2-3 minutes.
- Practice worksheets - learn by doing.
- Save videos for future reference in your own list.
- Extreme focus - no extra clutter or complexity.
- Core skills you can use again and again.
- Lifetime access - work at your own pace.
- No ads when you are logged into Exceljet :)
- 100% satisfaction guarantee - we want you to be happy.
Use this special link to save 25% until December 23:
https://exceljet.net/training?code=HOLIDAY22
Free resources
Although we offer paid training, many of our resources are free! See this page for a list of resources we provide:
https://exceljet.net/excel-topics
Have a fun and safe weekend!
Dave
