Excel Magic Trick #204: Adding w Case Sensitive Criteria
4,242 views · Published 9 January 2009 · 2:33 · Indexed 26 October 2026
Channel: excelisfun · 2009 · Science & Technology
Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT185-202.xls Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT185-202Finished.xls Full Page With All File Links: http://people.highline.edu/mgirvin/excelisfun.htm 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).
More from this channel
-
3:51
YouTubersLoveExcel#19: Steady Growth Cash Flow Formula
-
3:44
YouTubersLoveExcel#26: Text To Column Trouble
-
3:41
YouTubersLoveExcel#26.2: Formulas do not like TEXT Time
-
3:30
YouTubersLoveExcel#34: Hide Columns Copy Problem
-
9:27
YouTubersLoveExcel#31: Dates, Cash Flow & Logic
-
1:57
YouTubersLoveExcel#36: VLOOKUP increase based on Rating
-
7:38
YouTubersLoveExcel#52: VLOOKUP & Workbook References
-
1:39
YTLE#60: Hide Columns by Grouping