Using the result of formula as part of reference to a cell in
Thanks Gary, but what I do with this formula?
=CONTAR.SI($K$7:$K15;"" &N(K452))/$A15
I want to change the 15, I have the number in a cell " AN22" and I want to
use it instead of the 15
How I do that?
"Gary''s Student" wrote:
1. you have explained it very well
2. your goal is very smart and can be applied to links, hyperlinks, as well
as cell references
=INDIRECT(C22)/F33
--
Gary''s Student - gsnu200718
|