SUMIF

[Gary Thomson]

Hi There,

Is it possible to have a SUMIF statements that includes
the condition "CONTAINS ...."

i.e.

I have a list of posts such as Unit Manager, Admin
Assistant, Assistant Manager, Care Worker, which are in
the range B2:B60, which attached values in C2:C60

If I put "Manager" in cell E2, then can I get a SUMIF
statement to sum all values in C2:C60 if their
corresponding cell in B2:B60 contains the word Manager?

i.e.


A B C
1 Unit Manager £20,000
2 Admin Assistant £10,000
3 Assistant Manager £18,000
4 Care Worker £15,000

In the above (small) list, I want all managers posts
grouped together, so the SUMIF would give the answer
£38,000.

Is there a way to do this, other than using two separate
SUMIF statements (one for "Unit Manager" and one
for "Assistant Manager")???

Many Thanks,

Gary.

 

[Jerry W. Lewis]

There may be a more elegant way, but
=SUMPRODUCT(ISNUMBER(FIND("Manager",B2:B60))*C2:C60)
works

Jerry

 

[Frank Kabel]

Hi
try
=SUMIF(B2:B60,"*" & E2 & "*",C2:C60)