Brand Grouping
 

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!

Brand Grouping
 

Use a SumIf formula. Example:
=SUMIF(A:A,"Brand A",B:B)

Or you can store the Brand A text in a cell (C2 in the example below)
and reference it in the formula:
=SUMIF(A:A,C2,B:B)

Gecko wrote:
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!

Brand Grouping
 

Hi JW,

Unfortunatelly this doesn't work.

50g/60g/... are also in the same cell as the brand and SUMIF only takes full
cell content in account.

Thanks anyway for your reply !

"JW" wrote:

Use a SumIf formula. Example:
=SUMIF(A:A,"Brand A",B:B)

Or you can store the Brand A text in a cell (C2 in the example below)
and reference it in the formula:
=SUMIF(A:A,C2,B:B)

Gecko wrote:
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!

Brand Grouping
 

Hi again,

By adding * behind the brandname, I get the result I want.

Thanks a lot !!

"Gecko" wrote:

Hi JW,

Unfortunatelly this doesn't work.

50g/60g/... are also in the same cell as the brand and SUMIF only takes full
cell content in account.

Thanks anyway for your reply !

"JW" wrote:

Use a SumIf formula. Example:
=SUMIF(A:A,"Brand A",B:B)

Or you can store the Brand A text in a cell (C2 in the example below)
and reference it in the formula:
=SUMIF(A:A,C2,B:B)

Gecko wrote:
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!