Excel Magic Trick 777.5: SUMPRODUCT Function OR Criteria, 2 Tips: TRUE+FALSE & TRUE+TRUE

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)

Category:

Science & Technology

Tags:

• Excel
• 2007
• 2010
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• Slaying
• Dragons
• SUMPRODUCT
• OR
• criteria
• for
• adding
• and
• counting
• inside
• the
• function
• Boolean
• logic
• uses
• plus
• symbol

[krn14242]

Just Googled "ExcelisFun" and see the link to Microsoft Help. I provided some feedback regarding compensation to you Mike. You do all the work and they benefit from it by linking people to you versus MS doing their own work.

krn14242

[ExcelIsFun]

Thanks krn14242!! MS did contact me and said they were sorry for not letting me know that their internal Help menu pointed to my videos - it is not just a google link, if you are in Excel and use there Help to search for "formulas" and your help is connected to online, my videos will be listed.

[Dubz229]

I had a feeling you didn't! Seemed like something you would have proudly mentioned in a video! By typing in "Excelisfun" in google it came up with the link below. I'm not sure how many others they have linked other than this one. They do credit you, but they require approval. For some reason it wont let me post the link, check your email.

[ExcelIsFun]

Thanks, I'll check my e-mail.

[ExcelIsFun]

No. I had no idea. Tell me what and where they are linking.

Microsoft usually treats me with indifference or near contempt, so I am quite surprised.

[Dubz229]

@ExcelIsFun by the way, did you know that microsoft links to your tutorials now??? :)

[ExcelIsFun]

Yes, to understand this video, you would have had to study Excel quite a lot. For example, Video 777 has A LOT of new concepts and you must understand all the concepts from that video before getting to this video. But here is the good news:

If something is hard to learn, it is because the thing you are learning is filled with many new ideas. This means if you fight through all the new ideas and assimilate them into your head, you have won the battle and gained great new knowledge!!

[ExcelIsFun]

I am glad that you like it!

[ExcelIsFun]

You are welcome!