Do you mean something like this:

...........A..........B
1........D..........B
2........X..........Y
3........X..........C
4........C..........X
5........X..........Y

Count instances where column A = X and the same row in column B = Y ?

=SUMPRODUCT(--(A1:A5="X"),--(B1:B5="Y"))

The result is 2.

A better way to do this is to use cells to hold the criteria:

D1 = X
E1 = Y

=SUMPRODUCT(--(A1:A5=D1),--(B1:B5=E1))

--
Biff
Microsoft Excel MVP


"Bec" wrote in message
...
What would my formula look like if I had 2 conditions that needed to be
met
and then for any that met that condition to count those instances, in this
case it is all text entries.

Thanks
Bec