Set external cell filter for a range

N

nastech

Hi, I am trying to embed a cell designation for a range, can it be done?
thanks
for each of: (replace the 137 & 1150 with absolute cells?)

=MIN(IF(ISNUMBER(BK137:BK1150),BK137:BK1150,1E+100))

and
=SUMPRODUCT(--(LEFT(R137:R1150,1)="x"))

cntrl-shift-enter
 
N

nastech

Thanks anyways, realized unlike "in-document" links, cells move with
cut-paste for use of a fixed reference..
 
Top