See reply from Mr McGimpsey re this question and please do not start a new
thread on the same subject.......

=SUMPRODUCT(((A1:A1000=C1) + (A1:A1000=C2) + (A1:A1000=C3)), B1:B1000)


"my" wrote:

Hi,

I'm trying to use sumproduct with multiple criteria but in a single column.
The data looks like this:

A B
Salary 500
Bonus 400
Fringe 300
Travel 100
Entertainment 100

I want to sum column B that fits the criteria of "Salary", "Bonus", "Fringe"
in column A.

Is there a way to do an array formula or something where the formula checks
through column A and sums all values that meet the criteria of "Salary",
"Bonus", "Fringe"?

Thanks!