=SUMPRODUCT((Oct2009!$AV$2:$AV$3009=$A2)*(Oct2009!$AW$2:$BG$3009=E$1))

Is the answer, it appears... but I cannot begin to make common sense of it in my head. I would have thought that would have multiplied 110 by 2295, which is not what I wanted so I never even thought of looking there...

Now, I need one more thing....

Sometimes, rows in the original may show up like this:

Pie| *** Nothing to its right ***
Turnover| *** Nothing to its right ***
Pie| *** Nothing to its right ***

How do I count how many times "Pie" shows up with no flavor??