# Sumproduct alternative

#### Alph0427x

##### New Member
Hello,

I'm working on a relative big file, almost 14,000 cells which all of'em contain sumproduct...

As you would expect, its very slow. I would like to know if there's an alternative to sumproduct for this particulare case...

This is my formula:
=SUMPRODUCT(SUMIF(Finanzas!\$G\$3:\$G\$20000,CONCATENATE('Importe T. x Área'!\$O5:\$S5,"-",'Importe T. x Área'!W\$3),Finanzas!\$O\$3:\$O\$8706))

Finanzas!\$G\$3:\$G\$20000 - Criteria Range
CONCATENATE('Importe T. x Área'!\$O5:\$S5,"-",'Importe T. x Área'!W\$3) - Criteria (Array)
Finanzas!\$O\$3:\$O\$8706 - SumRange

Thanks for the help!

### Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

#### JackDanIce

##### MrExcel MVP
In...

=SUMPRODUCT(SUMIF(Finanzas!\$G\$3:\$G\$20000,CONCATENATE('Importe T. x Área'!\$O5:\$S5,"-",'Importe T. x Área'!W\$3),Finanzas!\$O\$3:\$O\$8706))

the condition range and the sum range are not equal in size!

Does the following yields some improventment in speed?

=SUMPRODUCT(Finanzas!\$O\$3:\$O\$8706,--ISNUMBER(MATCH(Finanzas!\$G\$3:\$G\$8706,'Importe T. x Área'!\$O5:\$S5&"-"&'Importe T. x Área'!W\$3,0)))

Replies
0
Views
186
Replies
0
Views
149
Replies
0
Views
103
Replies
5
Views
91
Replies
0
Views
180

### Forum statistics

1,190,735
Messages
5,982,646
Members
439,789
Latest member
Justhavinaltlfun2002

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