Counting if results across rows on another sheet?

Hello. Help would be deeply appreciated. I've tried a variety of things and formulas to get things to work but I am not having success at all. I've cleared everything out and I'm ready for help

In my spreadsheet, I have people's names in a table on a sheet named 02 February . Starting at B2 and going downward their names may be duplicated many times for shifts they worked. The column name is EmployeeName.

Across from them in columns BE through BN are dollar amounts of money they put into a safe.

I have an info tab and on it, each person's name is entered in a column, listed downward starting in G7.

I need to find each instance of each person's name on the 02 February sheet in Column B or the EmployeeName Column, read the amount of each safe drop they did across from their name in columns BE through BN, and count the number of times one of the dollar amounts exceeded 200.00 and place that number starting in column I starting at I7 on the Info Sheet. The counted number of times the drops exceeded 200 should correspond with their names in G7 on the Info sheet.

Originally Posted by bebo021999

Try in I7:

Thank you! This works perfectly. I was looking at index match and all kinds of crazy things. Thank you so much.