Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 18 May 2024 18:02:28 +0000
Post From: Spreadsheet functions INDIRECT & CONCATENATE examples
| [2016-03-25 03:38:39] |
| User553714 - Posts: 184 |
|
Hi, I am trying to use a combination of concantenate to form a reference to a cell range from text i.e =CONCATENATE("BC3:", "BC", TEXT(H54)) which returns BC3:BC7 I am then trying to use INDIRECT to use that text formed cell reference to return for example the sum of that range =SUM(INDIRECT(CONCATENATE("BC3:", "BC", TEXT(H54)) )) but I keep on getting #REF! or #SYNTAX! Is it possible to use text ranges with SC spreadsheet function INDIRECT and can you please provide an example of how I can do this? Regards |