View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Edwin Castro
 
Posts: n/a
Default Conditional count of rows dependent on multiple columns

Hi

I'm want to count rows in a worksheet given the following condition:
count row if ((column A has "*approved*") AND (column B,C,D, or E has
"failed"))

In the second condition I'd like to count the row if any of those
columns has "failed".

I'm trying to setup a function (or somethign) where I can then get a
total count given a range of rows.

Any ideas?