Forum Discussion

wyboooo's avatar
wyboooo
Copper Contributor
Nov 08, 2022

How to sum across tables

I've got three sheets.  Sheet1 has columns 'id' and 'hid. Sheet2 has columns 'id' and 'cnt'. Sheet3 has columns 'hid' and 'cnt'. The 'cnt' is calculated by adding the 'cnt' in Sheet2, where Sheet2...
excel
Harun24HR's avatar
Harun24HR
Bronze Contributor
Nov 08, 2022

wyboooo FILTER() with BYROW() then SUM() may work. See the attached file.

=SUM(BYROW(FILTER(Sheet1!$A$2:$A$8,Sheet1!$B$2:$B$8=A2),LAMBDA(x,XLOOKUP(x,Sheet2!$A$2:$A$8,Sheet2!$B$2:$B$8,0,0))))

Resources