can an array formula do this?
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.
|