software

Hi

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

In the second condition I'd like to count the row if any of those
columns has quot;failedquot;.

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

Any ideas?If there will only be one occurrence of 'Failed' in any row, try...

=SUMPRODUCT((A1:A10=quot;Approvedquot;)*(B1:E10=quot;Failedquot;))

Otherwise, try...

=SUM((A1:A10=quot;Approvedquot;)*(MMULT(--(B1:E10=quot;Failedquot;),TRANSPOSE(COLUMN(B1:E
10)^0))gt;0))

....confirmed with CONTROL SHIFT ENTER, not just ENTER.

Hope this helps!

In article . comgt;,
quot;Edwin Castroquot; gt; wrote:

gt; Hi
gt;
gt; I'm want to count rows in a worksheet given the following condition:
gt; count row if ((column A has quot;*approved*quot;) AND (column B,C,D, or E has
gt; quot;failedquot;))
gt;
gt; In the second condition I'd like to count the row if any of those
gt; columns has quot;failedquot;.
gt;
gt; I'm trying to setup a function (or somethign) where I can then get a
gt; total count given a range of rows.
gt;
gt; Any ideas?