Wow thank you that's great! I think I manipulate the criteria (B15:B17) based on =cell(address) and =indirect

Can you tell me what "*" does? Does that change "Category 1" to a number by any chance?

Also I thought I knew how sumproduct worked - but it doesn't seem like anything is being multiplied here? Just grouping and then simple adding?