Hi All,
I've attached an example sheet, the first tab breaks out prices and categories of components for a range of products, the second sums the total cost of the products and lists some configurations that they can be grouped in and I need some help on the third sheet. Essentially what I want is to see the total value of each category in any given configuration. I have filled in column C with a formula that works but its a massive repeating beast and has to be amended each time a new product is added which isn't ideal.
What I think I need is a SUMPRODUCT where one of the ranges is a list of values, each of which is the result of a SUMIFS.
Any questions, please ask!!
Bookmarks