Forum Discussion
Summing value based on common ID between two different sheets
Hi all, I am trying to sum a certain value based on certain criteria between different sheets. In the below picture, I would like to sum the Total GLA based on the Asset Manager. ...
In row 2 of the Total GLA (Sq. Fr.) column:
=SUMIF('GLA Sheet'!A:A, INDEX('Manager Sheet'!A:A, MATCH(A2, 'Manager Sheet'!E:E, 0)), 'GLA Sheet'!K:K)
where:
GLA Sheet is the name of the worksheet containing the GLA information; column A contains the ID and column K the GLA.
Manager Sheet is the name of the worksheet listing the Asset Managers; column A contains the ID and column E the name.
If you have Microsoft 365 or Office 2021, you can replace INDEX('Manager Sheet'!A:A, MATCH(A2, 'Manager Sheet'!E:E, 0)) with XLOOKUP(A2, 'Manager Sheet'!E:E, 'Manager Sheet'!A:A)