Can someone give me more examples of DSUM?
 

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.

Can someone give me more examples of DSUM?
 

=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.

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.