hi
countif wont do that but sumproduct will.
=sumproduct((A:A = "somecondition")*(B:B="someothercondition"))

read up on sumproduct and see this site....
http://www.contextures.com/xlFunctio...tml#SumProduct

regards
FSt1

"Chad Portman" wrote:

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.