SUMIF only it has 3 ceretain texts in the same row

V

vane0326

I change the 1 to text now it gives me a zero. What else should we do?

Thanks!
 
M

Max

RagDyer said:
=SUMPRODUCT((A2:A100="Pattern
Change")*(B2:B100=1)*(C2:C100="Machine")*E2:E100)
Click to expand...

vane0326 said:
I change the 1 to text now it gives me a zero. What else should we do?
Click to expand...

Text criteria need to be within double quotes,
e.g.: "Machine", "Pattern Change"

If col B may contain both text and numbers, and
assuming the criteria for col B will be input in say, cell F2
(instead of hardcoded in the formula), and with TRIM() used
to clean up any stray spaces for improved text matching,
then perhaps one way to harmonize it would be :

=SUMPRODUCT((TRIM($A$2:$A$100)="Pattern
Change")*(TRIM(TEXT($B$2:$B$100,"@"))=TEXT(F2,"@"))*(TRIM($C$2:$C$100)="Mach
ine")*$E$2:$E$100)
 
Top