I used the same function and still got the #REF!how can I solve this ?

Hi Sonia, To help you out, I need to know the function format you have used.

Follow this topic