Hello, are there any formulas that allow yo...

(Danni Paige) #1

Hello,

are there any formulas that allow you to link

2 tables together?

(Levent KULAÇOĞLU) #2

@Danni_Paige can you elaborate your query? You can use REF column type to link to tables together. Are you looking for something else?

(Danni Paige) #3

Basically, i would like to add up 2 Columns that are on a different sheet and have the grand total column on the main sheet display that data, is there a way to do this?

(Danni Paige) #4

@Levent_KULACOGLU

(Levent KULAÇOĞLU) #5

Of course @Danni_Paige. You can use SUM function along with either SELECT(…) or ANY(SELECT(…)) functions to get the desired result. You can also get these values to a Virtual Column with above formulas and then calculate a simple addition like [Virtual Column1]+[Virtual Column2]

(Danni Paige) #6

@Levent_KULACOGLU

In the main spreadsheet there is the Total Column, is it possible to add up multiple rows within a different spreadsheet? if so can you please explain how to do that?

(Levent KULAÇOĞLU) #7

@Danni_Paige in your [Total] column in the main spreadsheet, you want to get a total from multiple rows from different sheets, am I correct?

(Danni Paige) #8

@Levent_KULACOGLU multiple rows in the same spreadsheet, I basically have multiple items and each has the Job Number of the job they are related too if any of the items have the same Job Number I want there total added up and displayed within the total amount column for the relating job that is in a different sheet

(Levent KULAÇOĞLU) #9

SUM(SELECT(TableName[ColumnName],[Job Nr]=[_THISROW].[Job Nr]),SELECT(TableName2[ColumnName2],[Job Nr]=[_THISROW].[Job Nr]))