Fomula Too Long when Applying Names to ranges....

**rau** · 07-22-2010, 09:03 AM

Hi all

I'm attempting to replace some range references in my formulae with defined Names. A typical formual looks like this:

=IF($C13="T",SUMIFS($I$10:$I$421,$A$10:$A$421,CELL("contents",$A13),$C$10:$C$421,"=B",$D$10:$D$421,">30 Jun 2008",$D$10:$D$421,"<1 Jul 2009"),"")

I've defined names for the 4 distinct ranges you see in this formula.

When I attempt to apply these names, Excel responds with: "Formula is too long. Formulas may not exceed 8192 characters." [Note: I'm using Excel 2010.]

Any ideas?