Hello, I am wondering if it is possible to use the sumproduct or sumif
function (or some other function, or perhaps the use of array
formulas, or some other trick) in order to do the following.

For example, for:

Column A     ColumnB
apple            10
orange          12
tomato          23
blueberry       18
etc                etc

How can I say to excel: "sum corresponding data in column B, If column
A has: 'apple' or 'orange' or any of about 15 other items."  In
essence, I need to do an OR query with many potential matches.  Is
there a way to do this? Can I refer to a range of items within the
Sumif or sumproduct or vlookup formula?

I originally tried using a long sumproduct formula, but it got to be
incredibly long, and didn't seem to work....

Note that this is a formula that I will be using over and over to
extract data from a report, based on the medical service categories of
numerous states, and grouped under numerous dates.

FYI, the end result will look something like this for each State, as
will be pulled from a daily (dynamic) report:

              Day 1         Day 2 Etc......
Medical    Formula      Formula
Surgical   Formula      Formula
Neonatal  Formula      Formula
Etc

Thanks for any thoughts.....