Using cell reference and wildcards in a forumla

[steev_jd]

Hi,

I have a table where I need to total all the subsections of one colum
in to another column

i.e.
-------A--------------¦-------B--------¦---------C--------¦-------D----------¦
Trainers
Red........¦..........9.........¦...Trainers......¦........21..........¦
Trainers
Blue........¦.........3.........¦.....T-Shirts......¦..........10..........¦
Trainers
Yellow.....¦.........9.........¦......Etc............¦..........Etc........¦
T-Shirt
Green.......¦.........5.........¦......Etc............¦..........Etc........¦
T-Shirt
Red..........¦.........5.........¦......Etc............¦..........Etc........¦

I am trying to use a formula like the one below, (although I am no
sure if this in entirely right)

=SUMIF(A1:A9,"Trainers*",B1:B9)

However, rather than type 'trainers' I want the formula to call it fro
another cell .i.e.

=SUMIF(A1:A9,C1,B1:B9)

but i still need the wildcard at the end, so the formula will basicall
total all entries that begin with the word 'Trainers', the next wil
total all the begin with T-Shirt etc.

Any ideas on how to do this?

Thanks in advance,
Stev

 

[Dav]

=SUMIF(A1:A9,C1&"*",B1:B9)

Regards

Dav

 

[steev_jd]

Hi,

Thanks for your response but I am afraid it doen't work. I just ge
every column equaling 0.

Any further suggestions?

Cheers,
Stev

 

[steev_jd]

Sorry - That does work!! Thanks!