Excel Spreadsheet access from other Spreadsheet

ExcelNoob1996

New Member
Joined
May 28, 2018
Messages
2
Hey Guys,
What i basically want to do is the following:

i have a huge chunk of data (Data!) in one spreadsheet and want to choose one specific Collumn from where to add the sum. Here comes the trick: i dont want the specific collumns to fixed i want them to be able to change for example from I to K which is already possible to be switched in the Conclusion! spreadsheet now i want go ahead in the Conclusion spreadsheet and add everything in Data with the collumn deposited also in Conclusion as C8 with the value 1. I´ve already tried it like this: =SUMIF("Data!"&Conclusion!C8;1).
But that doesn´t really work
Has someone got any ideas?
Thanks in advance :)

EDIT: Here some visual addition to my issue:
ABCD
AdressMoreTestExample

<tbody>
</tbody>
this is the Spreadsheet with the data chunk
ABCDEFGH
1Collumn:A:A
2=SUMIF("Data!"&Conclusion!B1;1)
3
4
5
6
7
8
9

<tbody>
</tbody>
 
Last edited by a moderator:

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

JonXL

Active Member
Joined
Feb 5, 2018
Messages
455
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Code:
=IFERROR(SUM(INDIRECT("Data!"&B1&":"&B1))+1,"")

In B1, just enter the letter of the column (the formula will adjust the reference to include the colon) - for example, entering I will reference Data!I:I.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,580
Messages
5,637,211
Members
416,961
Latest member
sigrid6940

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top