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 ev...
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...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...



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.