maybe try the sumproduct function. i have a dislike of pivot tables,
and try to replace them with sumproduct functions where possible.