# SUMPRODUCT Question?

#### gtbb

##### Board Regular
Hi All,

Is there an alternative way to shorten the below formula?

Thanks a lot!

SUMPRODUCT(--('All Transactions'!\$A\$2:\$A\$3000=A9),--('All Transactions'!\$C\$2:\$C\$3000="INTEREST"),'All Transactions'!\$B\$2:\$B\$3000)+SUMPRODUCT(--('All Transactions'!\$A\$2:\$A\$3000=A9),--('All Transactions'!\$C\$2:\$C\$3000="INTEREST ADJUSTMENT"),'All Transactions'!\$B\$2:\$B\$3000)+SUMPRODUCT(--('All Transactions'!\$A\$2:\$A\$3000=A9),--('All Transactions'!\$C\$2:\$C\$3000="INTEREST ADJUSTMENTS"),'All Transactions'!\$B\$2:\$B\$3000)

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

#### Domski

##### Well-known Member
Maybe:

=SUMPRODUCT(--('All Transactions'!\$A\$2:\$A\$3000=A9),--(LEFT('All Transactions'!\$C\$2:\$C\$3000,8)="INTEREST"),'All Transactions'!\$B\$2:\$B\$3000)

Dom

#### pgc01

##### MrExcel MVP
Hi gtbb

Domski solution will work for any string that starts with "INTEREST". If you want to allow only the exact strings in your post:

#### gtbb

##### Board Regular
Wow! They both work so great!!

A big thanks to Domski and pcg01!!!!!!

Replies
0
Views
102
Replies
5
Views
153
Replies
8
Views
164
Replies
3
Views
200
Replies
1
Views
107

1,190,959
Messages
5,983,863
Members
439,867
Latest member

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