Quote Originally Posted by Jacc View Post
Fotis, do you mean $G6 and not G$6?
YES that is the correct if someone wants to drag the formula across. In this case even if anyone use the reference of the cell as i suggested the result will be ok.