DSUM formula

[Lowan Chan]

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

 

[Max]

A possibly easier, unambiguous way is to use sumproduct

To capture the amounts falling within any particular mth/year,
say amounts within Jun09:
=SUMPRODUCT(--(TEXT(A2:A9,"mmmyy")="Jun09"),C2:C9)

Above presumes dates in col A are real dates recognized by Excel
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik