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?
Bookmarks