Use cells to hold your criteria:

D1 = criteria to meet for column A
E1 = criteria to meet for column B

Then:

=SUMPRODUCT(--(A1:A100=D1),--(B1:B100=E1))

--
Biff
Microsoft Excel MVP


"Chad Portman" wrote in message
...
I have a list of data in coloumns A and B. I need to write a countif style
formula for if column A has one set of data in it while at the same time
column B has another set of data. So it should only count if the
conditions
for column A and the conditions in column B are met.