Hi Everyone,

I would like to have dynamic cell reference ie instead of having a set formula such as =countif(a1:d6,k5) have something where the cell number 1 and 6 is defined in other cells eg g1, g2.

can anyone help?

Thanks

Andre