Login Page - Create Account

Support Board


Date/Time: Wed, 12 Mar 2025 05:15:52 +0000



Post From: Spreadsheet Calculations in a Different Sheet?

[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