Support Board

Date/Time: Sat, 10 May 2025 00:16:10 +0000

Post From: Spreadsheet functions INDIRECT & CONCATENATE examples

[2016-03-25 03:38:39] Link To Thread - Link To Post [Go To First Post]
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