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!

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!

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

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