JBeaucaire, i was just about to set the post to solve, but it seems there is another issue, it is unrelated to the formula, but when i saved my file with the indirect formula, and sent it via email to my boss and customer, all the cells displayed #ref.

is there a way for me to save the cell data?

Thank you in advance

Cheers
Kagiri