J
John Abetong
How to sum up the total of a particular column according to date range. For
example all data for the month of Jan 2006. Below is sample worksheet.
A B C
Date Item Amount
01/01/06 xxxxxxxx 100.00
01/08/06 yyyyyyyy 200.00
01/15/06 zzzzzzzz 150.00
01/22/06 mmmm 250.00
01/27/06 nnnnnnn 150.00
02/01/06 ddddddd 225.00
02/08/06 cccccccc 275.00
03/04/06 aaaaaaa 225.00
example all data for the month of Jan 2006. Below is sample worksheet.
A B C
Date Item Amount
01/01/06 xxxxxxxx 100.00
01/08/06 yyyyyyyy 200.00
01/15/06 zzzzzzzz 150.00
01/22/06 mmmm 250.00
01/27/06 nnnnnnn 150.00
02/01/06 ddddddd 225.00
02/08/06 cccccccc 275.00
03/04/06 aaaaaaa 225.00