Excel Magic Trick 777.5: SUMPRODUCT Function OR Criteria, 2 Tips: TRUEFALSE & TRUETRUE

Channel Avatar
Comment
X
Share
Excel Magic Trick 777.5: SUMPRODUCT Function OR Criteria, 2 Tips: TRUEFALSE & TRUETRUE
Excel Magic Trick 777.5: SUMPRODUCT Function OR Criteria, 2 Tips: TRUEFALSE & TRUETRUE
Download Excel Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT777.5.xlsx

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
1. Follow up video to Excel Magic Trick 777: SUMPRODUCT Function — Basics To Advanced (14 Examples)
2. Learn how to create OR criteria for adding and counting inside the SUMPRODUCT function when there is NO possibility of Two TRUEs
3. Learn how to create OR criteria for adding and counting inside the SUMPRODUCT function when there IS the possibility of Two TRUEs
4. See how Boolean logic for OR uses a plus symbol

also see: Excel Magic Trick 777: SUMPRODUCT Function — Basics To Advanced (14 Examples)

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *