Looks like it’s just producing random numbers. If you remove ‘the’ and only say ‘sum numbers above’, it’ll result in 10. You can also do the same with no numbers anywhere in the sheet and the result will still be 15 and 10.
You can even tell it to ‘sum the numbers from A1, A2, A3’ and it’ll yet again produce 15. As per the documentation, you should give it specific cells as context, e.g., ‘COPILOT(“sum the numbers”, A1:A3)’. I can confirm this works, though I’m not sure why as the prompt sent to the model should be the exact same.
Looks like it’s just producing random numbers. If you remove ‘the’ and only say ‘sum numbers above’, it’ll result in 10. You can also do the same with no numbers anywhere in the sheet and the result will still be 15 and 10.
You can even tell it to ‘sum the numbers from A1, A2, A3’ and it’ll yet again produce 15. As per the documentation, you should give it specific cells as context, e.g., ‘COPILOT(“sum the numbers”, A1:A3)’. I can confirm this works, though I’m not sure why as the prompt sent to the model should be the exact same.
Definitely more convenient than =SUM(A1:A3)