With the range name in A1:
=SUMIF(INDIRECT(A1),"X")
Tim C
"Oscar" wrote in message
oups.com...
I am trying to use a SUMIF funtion in which the "sum_range" is defined
as a named range of cells. If I include the range name in the formula
everything is fine. However, I want to have the range name in a cell
then refernece the "sum_range" portion of the SUMIF formula to the cell
that contains the range anem. Does not appear to work.
Any advice would be appreciated.
