Special SUMIF Formula

[shaqil]

Dear All,

I have some data in foolowing format

Name Amount
A-B 10
AB 20
B-A 10

I need sum of those who has "-" in their name i.e A-B and B-A.

Kindly do the needful.

Thnx in advance

 

[Guest]

Try something like this:

=SUMIF(A2:A4,"*-*",B2:B4)

Is that something you can work with?
***********
Regards,
Ron

XL2003, WinXP

 

[Guest]

Use: =SUMIF($A$1:$A$3,"*-*",B1:B3)

pls do rate

 

[Dallman Ross]

Name Amount
A-B 10
AB 20
B-A 10

I need sum of those who has "-" in their name i.e A-B and B-A.

One way:

=SUMIF(A:A,"*-*",B:B)

Kindly do the needful.

=dman=