Support Board
Date/Time: Tue, 11 Mar 2025 17:02:54 +0000
Spreadsheet Calculations in a Different Sheet?
View Count: 411
| [2022-04-29 01:55:27] |
| user_xyz - Posts: 453 |
|
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: 4182 |
|
This works: =SUM(sheet2!B4+sheet2!B5) |
| [2022-04-29 02:40:21] |
| user_xyz - Posts: 453 |
|
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: