How to sum amounts appearing in column C if the string "Manufacturing" is
appearing in any of the respective cells of Column B?

Something like:

=SUMPRODUCT(--(SEARCH("Manufacturing",B1:B6,1)0),C1:C6)

Column B may contain:
Manufacturing-Textile
Manufacturing-Spinning
Manufacturing-Steel

All should be added!

All help shall be highly obliged.

Thanx!