Support Board
Date/Time: Sat, 21 Dec 2024 17:55:52 +0000
Post From: New spreadsheet syntax
| [2014-12-07 06:52:23] |
| enemyspy - Posts: 306 |
|
Hi, I am looking for an alternative way to accomplish the following excel syntax formula within the syntax of the new sierra spreadsheets: =SUM(INDIRECT(ADDRESS(MATCH(1.001,SHEET1!$BO$1:BO20000,0),310,4,TRUE,"SHEET2")):INDIRECT(ADDRESS(MATCH(2,SHEET1!BO1:BO20000,1),310,4,TRUE))) or more simply sum( address("defines first half of range on other sheet) : address("defines second half of range on other sheet) Currently unable to define a range using address function. Is there another way to do this? |