- If a calculation is performed on multiple conditions in a single column its called a OR criteria (at least one of the condition should be satisfied)
- If a calculation is performed on multiple conditions from multiple columns it is called a AND criteria (all of the conditions need to be satisfied)