Thread: DSUM formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lowan Chan Lowan Chan is offline
external usenet poster
 
Posts: 22
Default 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