=SUMPRODUCT(--(A2:A4= "[management]" ),(B2:B4))
Your data is kind of hard to interpret, you might need to change B2:b4 to
I5:I8
or maybe 6 - 9?

--
Kevin Vaughn


"User" wrote:

A1 [Department] I5[Bonus] J5[Department]
A2 [management] $2303.00 [management] thats
criteria
A3 [Finance] $1206.00
A4 [management] $232.00

If I only had to only find Total bonus for management how can I do that.