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!

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!

Thanx pal,

But what if I am using multiple conditions like:

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

"T. Valko" wrote:

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!

=SUMPRODUCT(--(A1:A6="PAKISTAN"),--(ISNUMBER(SEARCH("Manufacturing",B1:B6,1))),C1:C6)


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"FARAZ QURESHI" wrote in message
...
Thanx pal,

But what if I am using multiple conditions like:

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

"T. Valko" wrote:

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!