View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron@Buy Ron@Buy is offline
external usenet poster
 
Posts: 345
Default countif with multiple conditions

Try:
=SUMPRODUCT(--(A1:A1000="your condition"),--(B1:B1000="your condition"))

"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.