Excel Forum
Similar Content
Exact Function - Case Sensitive Comparison in Excel
Tutorial: Case-sensitive comparison of two text strings or values in Excel. To do this, we use the E...
Case Sensitive Sorting in Excel
Tutorial: How to perform case sensitive sorting in Excel. Select a cell within the data that you wan...
Filter Data in Excel to Show Rows/Data That Meet Multiple Criteria for One Field - AutoFilter
Macro: This free Excel macro filters data in Excel based on multiple criteria for one field in th...

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.