Row Limitation in SUMPRODUCT

[Stephen]

Is there a limit on the number of rows that can be referenced in a
SUMPRODUCT's array reference? When I try to reference arrays with >~2200
rows the formular no longer works. My sumproduct formular is using two
criteria arrays and one array of results to sum.

Thanks for any help that can be offer.

 

[Gord Dibben]

The only limit I know of......you cannot use an entire column like A:A

See Bob Phillips' site for much on SUMPRODUCT formulas.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html


Gord Dibben MS Excel MVP

 

[Dave Peterson]

And that limitation goes away in xl2007.

The only limit I know of......you cannot use an entire column like A:A

See Bob Phillips' site for much on SUMPRODUCT formulas.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Gord Dibben MS Excel MVP