In om, shaqil
spake thusly:

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=