Summing Data From Another Sheet
I have a resource tracker that is set up to sum hours by resource using the =SUM(CHILDREN()) Function.
I also need to be able to sum hours by Project Code (Column 4), and Classification (Column 8) by Month.
Can someone advise on the best way to approach this? My first thought was to use a SUMIFS formula --
=SUMIFS([Jan 2020 Actual]:[Jan 2020 Actual], [Tenrox Code]:[Tenrox Code], "10110", Classification:Classification, "<>Temp Staff").
This works in the Sheet Summary, but I really need the values to appear on a sheet so I can roll them into a report. Is it possible to reference another sheet via a formula? Is VLOOKUP a better approach?
Thanks for any insight!