Excel Forum
Similar Content
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...
Delete Entire Rows Based on Predefined Criteria (Text)
Macro: This macro will allow you to specify certain criteria and then to delete rows based up...



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.