OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743

Microsoft Excel Tips and Tricks

Learn about aggregate calculations with conditions and criteria. Learn about an AND Logical Test, and then see how the FILTER function can help with OR Logical Tests and advanced conditional calculations.

Credit ExcelIsFun