Remove last character from string and sum product

[ABSTRAKTUS]

Hi all,

I'm confused now. Assume you have huge range of many different products on the left, dates on top and values within the range. Products look like: GREEN1, GREEN 2, GREEN3 etc. & YELLOW1, YELLOW2 etc.

Question: how do I make formula sum the values of all GREEN (regardless what number is at the end) of the day?

See dummy if I'm not clear enough...

Thanks a ton guys for your priceless ideas!

[Søren Larsen]

In N13:

=SUMPRODUCT(($M13=LEFT($B$12:$B$20,LEN($B$12:$B$20)-1))*1,C$12:C$20) and copy across.

[Down Under]

A wildcard operator should suffice:

=sumif($B12:$B$20,"*"&$M13&"*",C$12:C$20)

[ABSTRAKTUS]

Spot on! That does a trick! Thanks!