Support Board
Date/Time: Sat, 25 Oct 2025 16:47:29 +0000
Spreadsheet Calculations in a Different Sheet?
View Count: 517
| [2022-04-29 01:55:27] |
| user_xyz - Posts: 496 |
|
I know you can reference cells from other sheets but can you perform calculations from eg. sheet1 on data in sheet2. Example sheet1 in cell A1. =sheet2!SUM(B4+B5) returns a #syntax error. Either you can only reference cells or something is wrong with my entry of formulas. Thanks |
| [2022-04-29 02:33:24] |
| Sawtooth - Posts: 4278 |
|
This works: =SUM(sheet2!B4+sheet2!B5) |
| [2022-04-29 02:40:21] |
| user_xyz - Posts: 496 |
|
Ah thanks Tom! I didn't see that in the documentation and was following Excel protocol for reference.
|
To post a message in this thread, you need to log in with your Sierra Chart account: