Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sun, 05 May 2024 12:17:10 +0000
Post From: New spreadsheet syntax
| [2014-12-07 06:52:23] |
| enemyspy - Posts: 304 |
|
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? |