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!