Excel Forum



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


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





Got a Question? Ask it Here in the Forum.