SUMIF only it has 3 ceretain texts in the same row

[vane0326]

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

Thanks!

 

[Max]

=SUMPRODUCT((A2:A100="Pattern
Change")*(B2:B100=1)*(C2:C100="Machine")*E2:E100)

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

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)