SUMIF only it has 3 ceretain texts in the same row

V

vane0326

I did do the leading/trailing spaces and the formula you guys gave m
and it still does not work how can I post a sample of this sheet fo
you guys could look it over?

Thanks
 
M

Max

The problem was in the text phrase for col A:

"HUNTER-1 LARGE 20X24"
should have been:
"HUNTER-1 ( LARGE 20X24 )"

That's why the SUMPRODUCT returned zero
(maybe try copy > paste for long text phrases instead of typing <g>)

The corrected formula is hence for example, for criteria of "1" in col B:

=SUMPRODUCT((TRIM($A$2:$A$100)="HUNTER-1 ( LARGE
20X24 )")*(TRIM(TEXT($B$2:$B$100,"@"))="1")*(TRIM($F$2:$F$100)="PATTERN
CHANGE")*$D$2:$D$100)
 
Top