This partially works... seems I'd have to divide the product by 3 to get the
actual result... thoughts?

"Jacob Skaria" wrote:

Try

=SUMPRODUCT((C2:C345="Must")*(D2:D345={"Closed","A ccepted","Testing"})*
(J2:J345="XL")*(LEFT(I2:I345,3)="rpt"))

If this post helps click Yes
---------------
Jacob Skaria


"rweiss" wrote:

Trying to solve for the following:
Count if
1) Priority = "Must"
AND
2) Status < "Closed", "Accepted", or "Testing"
AND
3) Functional Area begins with "RPT"
AND
4) Estimated Effort = "XL"

Wondering how best to modify the formula below to represent parts 2 and 3
above. How to represent contains "rpt" or begins with "rpt" (if wildcards
were permitted this would be too easy!) and accommodate the variable status
values we wish not to include.

SUMPRODUCT(--(C2:C345="Must"),--(J2:J345="XL"),--(I2:I345="RPT"))

in a perfectly intuitive world, I'd write something like:

SUMPRODUCT(--(C2:C345="Must"),--(D2:D345<"Closed" OR "Accepted", OR
"Testing")--(J2:J345="XL"),--(I2:I345 CONTAINS "rpt"))

Thanks in advance,
Rik