Can someone give me more examples of DSUM?

U

User

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

Kevin Vaughn

=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?
 
K

Kevin Vaughn

Oops, the range sizes need to match. Use 5 - 7 or 6 - 8 instead of what I
said earlier.
--
Kevin Vaughn


Kevin Vaughn said:
=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 said:
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.
Click to expand...
Click to expand...
 
Top