# Sumif problem

#### Cloverken

##### Active Member
cell A1 has number 280010
cell A2 has number 260020
cell A3 has number 280320

cell B1 has number 10
cell B2 has number 15
cell B3 has number 25

in cell C1 I was trying to use =SUMIF(A1:A3,28&"*",B1:B3)
to sum numbers in column A that start with 28 but it does
not work what am I doing wrong?

Thank you

### Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

#### dave3009

##### Well-known Member
Perhaps a SUMPRODUCT

=SUMPRODUCT(--(LEFT(L2:L4, 2)="28"), M2:M4)

Might work a bit better

KR

Dave

#### Cloverken

##### Active Member
Thank you Dave that works great!

Replies
1
Views
156
Replies
1
Views
2K
Replies
10
Views
972
Replies
11
Views
448
Replies
16
Views
717

1,191,359
Messages
5,986,193
Members
440,010
Latest member
cdotshel

### 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