CONDITIONAL SUMMING
One way:
=SUMIF(B1:B6,"Manufacturing*",C1:C6)
Or:
A1 = Manufacturing
=SUMIF(B1:B6,A1&"*",C1:C6)
--
Biff
Microsoft Excel MVP
"FARAZ QURESHI" wrote in message
...
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!
|