Is there a way to do sumifs in a range which criteria is based on several headers without using a helper column?
In the table A1:D21, I wanted to create a summary below it (A23:D28) showing the total sum of each Team Leaders of their total Inbound and Outbound, and showing the grand total.
Normally what I would do is add a helper column adding the name of team leaders beside those agents to simply do sumifs. Is it possible to do this without the help of a helper column?