Look Who it Was Random video

Excel Magic Trick 683: 3 AND criteria & 3rd AND has OR criteria -- Add, Count & Conditional Format

4,932 views · Published 31 July 2010 · 11:36 · Indexed 22 October 2026

Channel: excelisfun · 2010 · Science & Technology

Watch on YouTube

Download Files:
https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT683-685.xlsx

For Data Analysis learn about AND & OR criteria and Boolean and see how to:
1) Counting with 3 AND criteria and the 3rd AND criteria contains an OR criteria
2) Adding with 3 AND criteria and the 3rd AND criteria contains an OR criteria
3) Conditional Formatting with 3 AND criteria and the 3rd AND criteria contains an OR criteria

Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm

More from this channel