Forum Discussion
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...
wyboooo Can give you three solutions. And there are probably more. See attached.
Power Query (A:B)
Power Pivot (D:E)
and dynamic array formulas (G:H)