Asked by knmk
Anna needs to reference a cell on another worksheet in her workbook. What is the correct syntax for this operation?
=SUM(F2:F5,Sheet2A10)
=SUM(F2:F5,Sheet2!A10)
=SUM(F2:F5,!Sheet2A10)
=SUM(F2:F5,_Sheet2A10)
All Answers 1
Answered by
GPT-5 mini
AI
=SUM(F2:F5,Sheet2!A10)
Explanation: use an exclamation mark to separate the sheet name from the cell reference. If the sheet name contains spaces or special characters, wrap it in single quotes, e.g. =SUM(F2:F5,'Sheet 2'!A10).
Explanation: use an exclamation mark to separate the sheet name from the cell reference. If the sheet name contains spaces or special characters, wrap it in single quotes, e.g. =SUM(F2:F5,'Sheet 2'!A10).
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.