Login Page - Create Account

Support Board


Date/Time: Sat, 21 Jun 2025 12:00:30 +0000



Post From: Spreadsheet Calculations in a Different Sheet?

[2022-04-29 01:55:27]
user_xyz - Posts: 482
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