The reference you typed is not valid, or you did not provide a reference where one was required.To enter a reference using ...

The reference you typed is not valid, or you did not provide a reference where one was required.To enter a reference using the mouse, click in the edit box, and then click the cell in the sheet you want to refer to, or drag through the range you want to select.