Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Better Examples for VLOOKUP and the like | Excel Worksheet Functions | |||
Copy DSUM Criteria Question | Excel Worksheet Functions | |||
Use of the DSUM formula to find exact matches in datatables | Excel Worksheet Functions | |||
DSUM frustrations | Excel Worksheet Functions | |||
DSUM frustrations | Excel Worksheet Functions |