What about if I want a table with the totals for all employees broken
down by BU and Month, without having to make a table for each employee?

Name, Jan, Feb, Mar, Apr, etc
John, 0, 200, 50, 622, etc
Jane, 100, 40, 20, 52, etc
Joe, 122, 493, 20, 94, etc

Name, BU1, BU2, BU3, BU4
John, 20%, 50%, 30%, 0%
Jane, 0%, 50%, 50%, 0%
Joe 10%, 0%, 0%, 90%

What I'm looking for:

All employees, Jan, Feb, Mar, etc
BU1, sumproducts
BU2, sumproducts
BU3, sumproducts

That's the array formula I'm looking for. Sorry, should've said that
in the original post.