Hello again Forum!!
i have sheet 1 which contains 3 charts of 3 teams. often agents will work with other teams and occasionally all 3.
i need to SUMIFS agents hours across all 3 teams (Sheet 2)
and AVERAGEIFS agents % across all 3 teams (Sheet 2)
as well as by job as you will see on sheet 2, but i may be able to get that from "agents" formula.
Any help is greatly appreciated, and ty guys very much for past help!!