Interesting SUMIF Problem

[jrohman]

Good problem to fix here.

In Sheet1, Column A shows you unit sale, and column B shows the name that corresponds to that unit sale. Column E shows for the title 'COLA', the 109 different size packages. In column E, I need to create a SUMIF that returns a given package total sale.

For instance, F2 will read, =SUMIF(B2,"COLA2L",A2). It will return the proper number.

F3 will read =SUMIF(B3, "COLA12p12oz", A3). This too will return the proper number.

What I want to know, is in the SUMIF, can I search for the word 'COLA', then search individually for each package ('2L', '12p12oz', '20oz' etc...)? On Sheet 2, I have a table set up that shows each package corresponded to the proper abbreviation. It might work into some sort of VLOOKUP within the SUMIF.

I'd like to do this because I have to do it for 15 different flavors. 15x109=1635 times I'd have to type it in manually every time instead. Catch my drift? If someone can help I can just click and drag.

Any help is appreciated.

Thanks,
jimbo