Try something like this:

=SUMPRODUCT(--(A1:A10="Joe"),--(B1:B10="Open"))

Better to use cells to hold the criteria:

D1 = Joe
E1 = Open

=SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1))

--
Biff
Microsoft Excel MVP


"Stevestock" wrote in message
...
I am needing a formula that will count text occurences in multiple columns,
similar to an a COUNTIF statment but using a filter quality. For example,
I
need to know for all rows with the name of Joe in one column, how many
times
Joe has a case "Open". I am using the 2000 version.