Excel Forum
Similar Content
Exact Function - Case Sensitive Comparison in Excel
Tutorial: (Video tutorial's page: Compare Values in Excel - Beginner to Advanced) Case-sensitive co...
Case Sensitive Sorting in Excel
Tutorial: How to perform case sensitive sorting in Excel. Select a cell within the data that you wan...
Compare Values in Excel - Beginner to Advanced
Tutorial: How to compare text, numbers, and dates in Excel - including case sensitive text comparis...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick #204: Adding w Case Sensitive Criteria


See how to use the SUMPRODUCT and EXACT functions in an array formula to add the sales for a sales representative where lower and upper letters matter (case sensitive) in the criteria (conditions).





Got a Question? Ask it Here in the Forum.