Named Formula Problem

P

Peter Haworth

I like to put calculations that are used in more than 1 place in a Name so
that if I need to change them I can just change them in one place. However
there is one calculation that will not work when it is referred to by name,
always returning the #VALUE error. Exactly the same calculation in a cell
works perfectly.

The calculation is :

-SUMIF(INDIRECT(ADDRESS(RowFirstData,COLUMN()+1)&":"&ADDRESS(ROW()-1,COLUMN(
)+1)),INDIRECT(ADDRESS(ROW(),COLUMN()+1)),INDIRECT(ADDRESS(RowFirstData,COLU
MN())&":"&ADDRESS(ROW()-1,COLUMN())))

RowFirstData is a name containing =ROW(Accounts!$A$3)

Any ideas?

Pete
 
Top