Excel Forum



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.