And that limitation goes away in xl2007.

Gord Dibben wrote:

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

On Tue, 2 Oct 2007 11:22:01 -0700, Stephen
wrote:

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.

--

Dave Peterson