hello. I can help you with your question.
If you want to have the formula on a different sheet and still refer to the first sheet all you have to do is precede the cell cord that's by the sheet name and an!. Like sheet1!
Have I answered your question or do you need additional information?
I would appreciate a moment of your time to rate my level of service, OK, GOOD, or EXCELLENT at your convenience.