M
Mr. Low
Dear Sir,
I need to sum invoices according to Month and Year as illustrated below:
May I know what formula I must input at cell E2 and copy down to get the
answers :
A B C D E
1 Date Mth / Yr Invoice Amount S. Total
2 21/02/2001 Feb-01 IV8047 200
3 08/02/2001 Feb-01 IV8048 350
4 28/02/2001 Feb-01 IV8049 100 650
5 01/03/2001 Mar-01 IV8050 500
6 05/03/2001 Mar-01 IV8051 660 1100
7 02/02/2002 Feb-02 IV8054 220
8 20/02/2002 Feb-02 IV8063 120 340
I try converting date to Month / Year format in column B and using formula
=IF(B2<>B3,SUMIF(B2:B8,B2,D28),""), but it does not work because all the
cells in column B are date values.
Thanks
Low
I need to sum invoices according to Month and Year as illustrated below:
May I know what formula I must input at cell E2 and copy down to get the
answers :
A B C D E
1 Date Mth / Yr Invoice Amount S. Total
2 21/02/2001 Feb-01 IV8047 200
3 08/02/2001 Feb-01 IV8048 350
4 28/02/2001 Feb-01 IV8049 100 650
5 01/03/2001 Mar-01 IV8050 500
6 05/03/2001 Mar-01 IV8051 660 1100
7 02/02/2002 Feb-02 IV8054 220
8 20/02/2002 Feb-02 IV8063 120 340
I try converting date to Month / Year format in column B and using formula
=IF(B2<>B3,SUMIF(B2:B8,B2,D28),""), but it does not work because all the
cells in column B are date values.
Thanks
Low