Excel Forum
Similar Content
AND Function - Check if All Arguments are True
Tutorial: The AND function in Excel checks if every argument you put in it evaluates to TRUE.  If e...
Guide to Referencing Other Excel Files with Formulas and Functions
Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p...
Sum Values from Every X Number of Rows in Excel
Tutorial: Add values from every x number of rows in Excel. For instance, add together every other va...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Magic Trick 728: COUNTIF & AND Functions Check Whether 3 Specific People Worked Together


Download file: http://people.highline.edu/mgirvin/
Learn how to check to see if the names Chin, Brandy and RC all appear in the same row with AND and COUNTIF functions and array tricks.





Got a Question? Ask it Here in the Forum.