Limits SUMPRODUCT

**ovidius** · 05-16-2013, 06:37 AM

Hi,

That is limits for one range/arrays of SUMPRODUCT?

Thanks,
ovidius

**milind.pawar** · 05-16-2013, 06:44 AM

What is your question?

**ovidius** · 05-16-2013, 06:54 AM

In this formula exist one limit in number of rows ?
Ex. SUMPRODUCT((A1:A1000000="*")*(B1:B1000000))

Thanks.

**Fotis1991** · 05-16-2013, 07:06 AM

In Excel<2007, almost 65000. In Excel>=2007, a little more than one million...

**Pepe Le Mokko** · 05-16-2013, 07:18 AM

Hit F1 and enter " limits and specifications" in the search field - It's all there

**ovidius** · 05-16-2013, 08:20 AM

Thanks.

ovidius

Re: Limits SUMPRODUCT