LinkBack URL
About LinkBacks
Hi,
Do I have to change a whole sheet if I just want to use R1C1 in a couple of cells? Or is it someway just to change a few cells. Best if I could write a formula that activated that cell for R1C1 notation.
Hi,
Do I have to change a whole sheet if I just want to use R1C1 in a couple of cells? Or is it someway just to change a few cells. Best if I could write a formula that activated that cell for R1C1 notation.
Have you tried using INDIRECT? That allows to refer to a cell indirectly via text. (remember, text can be pulled from cells too)
Also, INDEX function uses notaion (Array, row, column), so you can select large array and indirectly refer there to 'row 1 in my array, column 3 in my array' - just an example, giving you the same functionality.
As far as I know you can't use R1C1 notation and A1 notation on the same sheet at the same time.
Why do you need to use R1C1 notation for these cells?
If posting code please use code tags, see here.
hmm, gutkinma suggestions sounds like they will solve my problems.
I just needed it because cells I have to sum has to be a function from an ID, that is a number. If for instance Id 2, i have to sum certains columns in array AE1000:AK1100.
I will try with what gutkinmna suggested, thanks!
hmm I cant make it work.
I have a huge array, AD1001:XFD1251. Or a lot of small arrays in this huge one. I have to use SUMIFS for each Array. For Row 1 I have to sum range AH1001:AH1081 with criteria in column AK1001:AK1081.
For row 2 it should take 8 steps in columns, so sumrange will be AP1001:AP1081 and criteria range AS1001:1081.
I have created values of 1,2...380 for the different rows and was hoping to build a formula where I wanted the result to be presented. But it seems I can only take out specific cell values with INDEX.
To explain further I would like a formula like;
=SUMIFS(INDEX(AD1001:XFD1251;1001:1081;5);INDEX(AD1001:XFD1251;1001:1081;8);"<3")
First sum range will be column 5, and first criteria range will be column 8. 2nd sum range will be column 13 and 2nd criteria range will be column 16. When I write this formula it only returns #Value; I guess I can´t give an array in INDEX?
Last edited by samot79; 12-11-2014 at 06:36 AM. Reason: updated formula
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks