Can someone give me more examples of DSUM?
Oops, the range sizes need to match. Use 5 - 7 or 6 - 8 instead of what I
said earlier.
--
Kevin Vaughn
"Kevin Vaughn" wrote:
=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.
|