Shamsuddeen
Active Member
- Joined
- Feb 16, 2002
- Messages
- 292
Hi all!
I have a table with the following data:
Column A-Date Column B-Amount
01-Jan-2000 25000
12-Jan-2000 15000
18-Jan-2000 10000
20-Mar-2001 2500
25-Mar-2001 3000
01-Aug-2002 45000
02-Aug-2002 100
31-Aug-2003 650
and so on......
I would like to have the totat and count of amount per month as below:
Period Total Count
Jan-2000 xxxxx xx
Mar-2001 xxxxxx xx
Aug-2002 xxxxxx xx
Aug-2003 xxxxxx xx
Thanks for the help in advance.
Shamsuddeen
I have a table with the following data:
Column A-Date Column B-Amount
01-Jan-2000 25000
12-Jan-2000 15000
18-Jan-2000 10000
20-Mar-2001 2500
25-Mar-2001 3000
01-Aug-2002 45000
02-Aug-2002 100
31-Aug-2003 650
and so on......
I would like to have the totat and count of amount per month as below:
Period Total Count
Jan-2000 xxxxx xx
Mar-2001 xxxxxx xx
Aug-2002 xxxxxx xx
Aug-2003 xxxxxx xx
Thanks for the help in advance.
Shamsuddeen