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 |
DSUM formula
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 --- "Lowan Chan" wrote: 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 |
All times are GMT +1. The time now is 02:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com