SUMIF only it has 3 ceretain texts in the same row

V

vane0326

This looks very good formula but it still gave me a zero I modified it
how I wan it to come up. Please over it if I did somthing wrong.

Thanks!


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

Max

.. *(TRIM(TEXT($B$2:$B$100,"@"))=TEXT($B$2:$B$100)"@"))

You had a typo here: .. =TEXT($B$2:$B$100)"@")
should be .. =TEXT($B$2:$B$100,"@")

but typo aside, this part just doesn't make sense ..

You need to specify a criteria to replace the above part,
either a text phrase, say: "TEST" or a number: "1"
(Do note that the number *need* to be placed within double quotes)

So the corrected formulas could be either:

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

or

=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