It works in a test workbook for me.

Do you have a #VALUE! error in your data range?

Did you use the formula exactly? If not, did you make sure the range
sizes were the same?

In article ,
ub wrote:

It didn't work, it gives error message # Value


"JE McGimpsey" wrote:

One way (no need to array-enter):

=SUMPRODUCT(--ISNUMBER($A$4:$A$100), --(TRIM($C$4:$C$100)="C"),
--(TRIM($M$4:$M$100)<"Closed"), --(LEN(TRIM($M$4:$M$100))0))