G
Gecko
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!
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!