ExcelBanter - Special SUMIF Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Special SUMIF Formula (https://www.excelbanter.com/excel-programming/395327-re-special-sumif-formula.html)

Dallman Ross

Special SUMIF Formula

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=

All times are GMT +1. The time now is 09:33 PM.