Main Profile

At A Glance

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).
Length: 02:33

Contact

Questions about Excel Magic Trick #204: Adding w Case Sensitive Criteria

Want more info about Excel Magic Trick #204: Adding w Case Sensitive Criteria? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question