G
Guest
Dear Sir,
I have the following data sorted by date, may I know what formula must I use
to sum up items the belong to a similar period say Jun-06, Jul-06, Aug-06 at
column D ?
A B C D
1 Invoice Date Amount Sub Total
2 XXXXX 21/7/06 254.00
3 XXXXX 28/7/06 325.00 579.00
4 XXXXX 21/8/06 145.00
5 XXXXX 26/8/06 321.00 466.00
6 XXXXX 21/9/06 144.00
7 XXXXX 23/9/06 121.00 265.00
8 XXXXX 10/10/2006 321.00
9 XXXXX 16/10/06 147.00 468.00
10 XXXXX 11/11/2006 100.00
11 XXXXX 13/11/06 287.00 387.00
12 XXXXX 9/12/2006 988.00
13 XXXXX 16/12/06 125.00 1,113.00
TOTAL 3,278.00 3,278.00
Can you please show me the formulas if other data set is to be sum up by
date as well as by year ?
E.g. 1
A B C D ( Sub Total by date)
Xxxxx 9/12/06 xxxxx
Xxxxx 9/12/06 xxxxx xxxxxx
Xxxxx 12/12/06 xxxxx
Xxxxx 12/12/06 xxxxx xxxxxxxx
E.g. 2
A B C D ( Sub Total by year)
Xxxxx 9/12/04 xxxxx
Xxxxx 9/12/04 xxxxx xxxxxx
Xxxxx 12/12/05 xxxxx
Xxxxx 12/12/05 xxxxx xxxxxx
Thanks
Low
I have the following data sorted by date, may I know what formula must I use
to sum up items the belong to a similar period say Jun-06, Jul-06, Aug-06 at
column D ?
A B C D
1 Invoice Date Amount Sub Total
2 XXXXX 21/7/06 254.00
3 XXXXX 28/7/06 325.00 579.00
4 XXXXX 21/8/06 145.00
5 XXXXX 26/8/06 321.00 466.00
6 XXXXX 21/9/06 144.00
7 XXXXX 23/9/06 121.00 265.00
8 XXXXX 10/10/2006 321.00
9 XXXXX 16/10/06 147.00 468.00
10 XXXXX 11/11/2006 100.00
11 XXXXX 13/11/06 287.00 387.00
12 XXXXX 9/12/2006 988.00
13 XXXXX 16/12/06 125.00 1,113.00
TOTAL 3,278.00 3,278.00
Can you please show me the formulas if other data set is to be sum up by
date as well as by year ?
E.g. 1
A B C D ( Sub Total by date)
Xxxxx 9/12/06 xxxxx
Xxxxx 9/12/06 xxxxx xxxxxx
Xxxxx 12/12/06 xxxxx
Xxxxx 12/12/06 xxxxx xxxxxxxx
E.g. 2
A B C D ( Sub Total by year)
Xxxxx 9/12/04 xxxxx
Xxxxx 9/12/04 xxxxx xxxxxx
Xxxxx 12/12/05 xxxxx
Xxxxx 12/12/05 xxxxx xxxxxx
Thanks
Low