Hi,

I have a table where I need to total all the subsections of one column
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 not
sure if this in entirely right)

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

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

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

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

Any ideas on how to do this?

Thanks in advance,
Steve


--
steev_jd
------------------------------------------------------------------------
steev_jd's Profile: http://www.excelforum.com/member.php...o&userid=33107
View this thread: http://www.excelforum.com/showthread...hreadid=560167