I have tried both suggestions and they don't seem to work right. More info
may help:
In Column E Row 3 to 57 are various numbers - 1 through to 112 in column G
row 3 to 57 are either a T or F
I need to count how many times a number such as "14" in column E has a Y in
column G on the same row. i.e. Row 51 Column E = 14 column G = Y so would be
counted as 1 and if row 46 had the same criteria I would then have a count of
2 and so on.

"Krissy" wrote:

Hi
I need a formula that will look in one column range for a certain value and
for another value in another column range and when they are both found in the
same row, will count the number of occurances. Help!!!!