# Sum If

#### rhmkrmi

##### Active Member
Hello:

I am trying to use the sum if formula where in my "Range" data field, I am looking at differenet text strings all starting with the same text, for example, BA: Abcd, BA: Efgh, BA: Ijkl, etc etc.

I want to use sum if to sum all the ones that begin with "BA:" but cannot quite get there.

Thanks

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### njimack

##### Well-known Member
=SUMIF(A1:A10,"BA:*",B1:B10)

or

=SUMPRODUCT(--(LEFT(A1:A10,3)="BA:"),(B1:B10))

#### rhmkrmi

##### Active Member
Wonderful, thank you so much.

What do the -- do in the =SUMPRODUCT(--(LEFT(A1:A10,3)="BA:"),(B1:B10))?

Thanks

Replies
7
Views
108
Replies
1
Views
62
Replies
4
Views
111
Replies
1
Views
63
Replies
10
Views
522

1,130,445
Messages
5,642,194
Members
417,259
Latest member
gtacw

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back