P
Peter
Hi all
I am trying to find a formula that will sum the Value(s) were it matches the
specifed index number and where it falls between specific dates i.e. from
1/2/08 - 29/2/08
A B C
Index Invoice Date Value £
2 20/03/2008 £46,854.00
2 31/03/2008 £165,083.00
2 31/03/2008 £20,858.00
2 28/03/2008 £146,550.00
2 29/02/2008 £195,636.00
I have tried
=sum(if(a3:a7=2,if(b3:b7>=&Date(2008,02,01),if(b3:b7<=&Date(2008,02,29),(c3:c7) - ARRAY - but does not work
Any ideas?
I am trying to find a formula that will sum the Value(s) were it matches the
specifed index number and where it falls between specific dates i.e. from
1/2/08 - 29/2/08
A B C
Index Invoice Date Value £
2 20/03/2008 £46,854.00
2 31/03/2008 £165,083.00
2 31/03/2008 £20,858.00
2 28/03/2008 £146,550.00
2 29/02/2008 £195,636.00
I have tried
=sum(if(a3:a7=2,if(b3:b7>=&Date(2008,02,01),if(b3:b7<=&Date(2008,02,29),(c3:c7) - ARRAY - but does not work
Any ideas?