Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DSUM Basics
I am attempting to use DSUM in Excel 2003 and getting no results other than
#VALUE! errors. I cannot tell if this is because my Excel does not use the DSUM function or if I am making some fundamental mistake in using the function. The basic table is longer than the sample below: Start WC Req Sum 0 0 0 Start 0 0 0 WC 0 0 0 0 4300 66.461 40021 4300 0.023 =dsum($a1:$b200,"Req",$a$2:$b$3) 40021 4300 0.054 =dsum($a1:$b200,"Req",$a$2:$b$3) 40035 4300 1.667 =dsum($a1:$b200,"Req",$a$2:$b$3) 40037 4300 0.25 40039 4300 0.023 40042 4300 0.25 40043 4300 3.947 What I wish to do is to sum up Req in the "Sum" column for any value that matches "Start" and "WC" in that row. The formula should give a value of 0.077 for the first and second cells, 1.667 for the third, etc. but I get only an error message. What am I doing wrong? -- Midland |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
DSUM Basics
for multiple criteria, its generally easier to use SUMPRODUCT. Placing this
formula somewhere in row 2: =SUMPRODUCT(--(a$2:a$200=a2),--(b$2:b$200=b2),(C$2:C$200)) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Midland" wrote: I am attempting to use DSUM in Excel 2003 and getting no results other than #VALUE! errors. I cannot tell if this is because my Excel does not use the DSUM function or if I am making some fundamental mistake in using the function. The basic table is longer than the sample below: Start WC Req Sum 0 0 0 Start 0 0 0 WC 0 0 0 0 4300 66.461 40021 4300 0.023 =dsum($a1:$b200,"Req",$a$2:$b$3) 40021 4300 0.054 =dsum($a1:$b200,"Req",$a$2:$b$3) 40035 4300 1.667 =dsum($a1:$b200,"Req",$a$2:$b$3) 40037 4300 0.25 40039 4300 0.023 40042 4300 0.25 40043 4300 3.947 What I wish to do is to sum up Req in the "Sum" column for any value that matches "Start" and "WC" in that row. The formula should give a value of 0.077 for the first and second cells, 1.667 for the third, etc. but I get only an error message. What am I doing wrong? -- Midland |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual basics | Excel Discussion (Misc queries) | |||
Macro basics | Excel Discussion (Misc queries) | |||
basics? | New Users to Excel | |||
Hi I'm New and need help with Excel Basics | Excel Discussion (Misc queries) | |||
Excel Basics | Excel Discussion (Misc queries) |