Totaling sections within a list

[steev_jd]

Hi,

I have a very long list laid out in the fashion below;

T-Shirt Red 5
T-Shirt Green 6
T-Shirt Blue 3
T-Shirt Orange 7
Trainers White 8
Trainers Green 7
Trainers Blue 9
Shorts Blue 2
Shorts Red 3

Where cell A1 contains 'T-Shirt Red'
and cell B1 contains '5'

Is it possible to implement a formula that subtotals all of the
sections i.e.
T-Shirts 21
Trainers 24
Shorts 5
?


Thanks in advance,
Steve

 

[Bondi]

Hi Steve,

Maybe you can use SUMIF() and a wildcard *

Somethinge like:

=SUMIF(A1:A9,"T-shirts*",B1:B9)
=SUMIF(A1:A9,"Trainers*",B1:B9)
and
=SUMIF(A1:A9,"Shorts*",B1:B9)

Regards,
Bondi