Hi,

I'm working with a list of monthly sales figs with multiple brands, each
with multiple items. The description of the items is in 1 cell.

Month1 Month2 ...
Brand A 50g
Brand A 60g
Brand A ...
Brand B 40g
Brand B 60g
Brand B ...


Is there a way to make a sum (or other calculation) per brand, without
having to add a 'summary line' manually ?

I'm thinking of a formula that sums 1 month of all cells where the first
cell starts with "Brand A".

Thanks!