How to show a table as bellow using DSUM function in Excel?
The account amount has more than one record.
Sheet1:
A B C
1 ACCT Month YTD
2 10300000 1 10
3 11100000 2 11
4 11300000 3 12
5 11500000 4 13
6 12100000 5 14
7 12200000 6 15
8 12201000 7 16
9 12250000 8 17
10 12300000 9 18
11 12400000 10 19
12 10300000 1 10
13 11100000 2 11
14 11300000 3 12
15 11500000 4 13
16 12100000 5 14
17 12200000 6 15
18 12201000 7 16
19 12250000 8 17
20 12300000 9 18
21 12400000 10 19
22 10300000 1 10
23 11100000 2 11
24 11300000 3 12
25 11500000 4 13
26 12100000 5 14
27 12200000 6 15
28 12201000 7 16
29 12250000 8 17
30 12300000 9 18
31 12400000 10 19
Thhis is what I should get on Sheet2:
A B C
ACCT Month YTD
1 10300000 3 30
2 11100000 6 33
3 11300000 9 36
4 11500000 12 39
5 12100000 15 42
6 12200000 18 45
7 12201000 21 48
8 12250000 24 51
9 12300000 27 54
10 12400000 30 57
I am getting the following on Sheet2,that is not correct:
A B C
1 ACCT Month YTD
2 10300000 3 30
3 11100000 6 33
4 11300000 9 36
5 11500000 12 39
6 12100000 15 42
7 12200000 18 45
8 12201000 21 48
9 12250000 24 51
10 12300000 27 54
11 12400000 30 57
my formula: =DSUM(datatest,month,acct:A2) for the first cell.
datatest = a1:c30 on Sheet1
acct =A1
month = B1 on Sheet2
YTD = C1 on Sheet2