LinkBack URL
About LinkBacks
below is a copy of my small database and I can not for the life of me figure out why the DSUM function is not working where it says Totals 144 the 144 is where I have the following formula: =DSUM(A14:R360,"GMkt",A8:A11)
where A14 - R360 is the location of the data including the first line of titles, GMkt is the column that I am attempting to SUM and A8:A11 is where I have the two dates that I want to add between.
the formula I have in A9 and A11 is: =$C$5&TEXT($B$2,"mm/dd") where C5 is the operator and B2 is the actual date ... the formulas are the same for A9 & a11 other than B2 is B1 for the other and C5 is C4. Even if I take these formulas out and enter the information directly as: >3/1/2010 it still does not change the outcome ... so I do not believe that this formula is causing the problem ...
so, an end user would put in dates at the top and the rest are calculated below it.
The end result is that I can not get the formula to limit the sumation to between the dates it ALWAYS adds ALL of the data shown no matter what the corresponding dates are ....
the data below doesn't show very well ... but each number below is a separate column I am attempting to sum the 2nd column which is the first column of numbers to the right of the dates shown ... I didn't know how to get a better picture in there for illustration ...
Beginning Date 1-Feb
Ending Date 1-Mar
Beginning Date 1-Feb >=
No. to Show 8 <=
Date
>3/1/2010
<5/1/2010
Totals 144
Goal Result
Date GMkt GRec RMkt RRec
1/7 5 0 2 0
1/12 5 0 5 0
1/13 5 0 3 0
1/19 5 0 1 0
1/20 5 0 6 0
1/21 5 0 1 0
1/22 5 10 1 14
1/25 5 15 2 7
1/26 5 0 2 0
2/1 5 10 2 12
2/2 5 15 2 15
2/3 5 5 1 1
2/16 5 5 3 8
2/17 5 5 0 2
2/23 5 10 2 12
2/26 0 0 0 0
3/1 10 0 0 0
3/9 5 1 7 1
3/10 5 5 1 2
3/11 0 10 0 11
3/12 0 5 0 3
4/15 10 0 12 0
4/22 15 0 4 0
4/23 15 0 8 0
4/28 5 10 0 4
4/29 2 7 1 6
5/3 2 10 1 0
Register To Reply
Bookmarks