Hi all,
I have been trying to get a sum for three columns on a monthly basis. I would like to have a TOTAL amount at the bottom of columns or a given cell) C, D, and E but only if they are say from 01/26/04 (the 26th of the previous month) until 02/25/04 (After the 25th they are added to the next month information). This list actually has an entire year data but for brevity just pasted this info. My efforts to o a sumif statement arent working. Also, would i have to manually make changes in the formula for each month or is there a way for Excel to know that I want sums bound between the 26th of previous month to the 25th of current month the
Thanx a bunch everyone!, Sample file is below:
A B C D E
01/26/04 02/01/04 6,942 2,599 3,013
01/27/04 02/01/04 2,398 800 6,886
01/28/04 02/01/04 2,191 868 5,188
01/29/04 02/01/04 2,277 886 6,728
01/30/04 02/01/04 2,520 828 6,669
01/31/04 02/01/04 0 0 0
02/01/04 02/01/04 0 0 0
02/02/04 02/08/04 4,590 8 3,658
02/03/04 02/08/04 3,641 2,819 6,185
02/04/04 02/08/04 2,325 892 5,351
02/05/04 02/08/04 2,097 926 5,951
02/06/04 02/08/04 2,923 1,092 5,693
02/07/04 02/08/04 0 0 0
02/08/04 02/08/04 0 0 0
02/09/04 02/15/04 6,743 3,690 3,697
02/10/04 02/15/04 2,125 771 6,185
02/11/04 02/15/04 2,109 911 5,676
02/12/04 02/15/04 2,149 890 6,273
02/13/04 02/15/04 2,204 858 6,208
02/14/04 02/15/04 0 0 0
02/15/04 02/15/04 0 0 0
02/16/04 02/22/04 0 0 0
02/17/04 02/22/04 8,189 3,559 3,091
02/18/04 02/22/04 2,367 939 5,515
02/19/04 02/22/04 2,409 902 7,071
02/20/04 02/22/04 2,547 960 4,555
02/21/04 02/22/04 0 0 0
02/22/04 02/22/04 0 0 0
02/23/04 02/29/04 6,869 2,940 5,574
02/24/04 02/29/04 2,283 742 6,527
02/25/04 02/29/04 2,404 893 6,689
02/26/04 02/29/04 2,218 1,134 5,128
02/27/04 02/29/04 2,601 900 3,951
02/28/04 02/29/04 0 0 0
02/29/04 02/29/04 0 0 0
I have been trying to get a sum for three columns on a monthly basis. I would like to have a TOTAL amount at the bottom of columns or a given cell) C, D, and E but only if they are say from 01/26/04 (the 26th of the previous month) until 02/25/04 (After the 25th they are added to the next month information). This list actually has an entire year data but for brevity just pasted this info. My efforts to o a sumif statement arent working. Also, would i have to manually make changes in the formula for each month or is there a way for Excel to know that I want sums bound between the 26th of previous month to the 25th of current month the
Thanx a bunch everyone!, Sample file is below:
A B C D E
01/26/04 02/01/04 6,942 2,599 3,013
01/27/04 02/01/04 2,398 800 6,886
01/28/04 02/01/04 2,191 868 5,188
01/29/04 02/01/04 2,277 886 6,728
01/30/04 02/01/04 2,520 828 6,669
01/31/04 02/01/04 0 0 0
02/01/04 02/01/04 0 0 0
02/02/04 02/08/04 4,590 8 3,658
02/03/04 02/08/04 3,641 2,819 6,185
02/04/04 02/08/04 2,325 892 5,351
02/05/04 02/08/04 2,097 926 5,951
02/06/04 02/08/04 2,923 1,092 5,693
02/07/04 02/08/04 0 0 0
02/08/04 02/08/04 0 0 0
02/09/04 02/15/04 6,743 3,690 3,697
02/10/04 02/15/04 2,125 771 6,185
02/11/04 02/15/04 2,109 911 5,676
02/12/04 02/15/04 2,149 890 6,273
02/13/04 02/15/04 2,204 858 6,208
02/14/04 02/15/04 0 0 0
02/15/04 02/15/04 0 0 0
02/16/04 02/22/04 0 0 0
02/17/04 02/22/04 8,189 3,559 3,091
02/18/04 02/22/04 2,367 939 5,515
02/19/04 02/22/04 2,409 902 7,071
02/20/04 02/22/04 2,547 960 4,555
02/21/04 02/22/04 0 0 0
02/22/04 02/22/04 0 0 0
02/23/04 02/29/04 6,869 2,940 5,574
02/24/04 02/29/04 2,283 742 6,527
02/25/04 02/29/04 2,404 893 6,689
02/26/04 02/29/04 2,218 1,134 5,128
02/27/04 02/29/04 2,601 900 3,951
02/28/04 02/29/04 0 0 0
02/29/04 02/29/04 0 0 0