Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DSUM formula
I set a DSUM formular, but the result was not what I want. C12= Dsum(a1:c9,
c1, a11:a13). suppose it should only sum up c4 + c6, but the result also include c2. where did I made a mistake? Thanks. A B C 1 date item amount 2 8-Jul 1102 $677.00 3 7-Apr 1101 $56,579.00 4 3-Jun 1004 $8,733.00 5 7-May 5006 $890.00 6 5-Jun 1004 $775.00 7 5-May 1003 $45,679.00 8 7-Mar 1004 $763.00 9 9-Apr 5006 $875.00 10 11 date amount 12 =1-Jun 10185 13 <=31-Jun -- Lowan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dsum formula interpretation | Excel Worksheet Functions | |||
Old DSUM formula not working in Excel 2007 | Excel Worksheet Functions | |||
Wildcard for dsum formula | Excel Worksheet Functions | |||
Criteria field in dsum formula | Excel Worksheet Functions | |||
Formula similar to DSUM | Excel Discussion (Misc queries) |