Hi all,
Been having a spot of bother with getting a formula to work right.
Basically i need it to do this,
=SUMPRODUCT((Pending!G2:G6000>=A4)*(Pending!G2:G6000<A5))
which works fine in another column, aswell as this
=COUNTIF(Pending!E1:E6000,"*A8*")
which also works fine. I cant seem to get the two to combine or find an alternative to what im trying to do which is get a range of dates between two points in coloumn G (lets say 15/01/2009 and 22/01/2009) and from that selection tell me how many of them rows contain the phrase "A8" in coloumn E. Iv tryed many different formulas and arrays but cant seems to get it right.
Any help would be much appreciated.
Been having a spot of bother with getting a formula to work right.
Basically i need it to do this,
=SUMPRODUCT((Pending!G2:G6000>=A4)*(Pending!G2:G6000<A5))
which works fine in another column, aswell as this
=COUNTIF(Pending!E1:E6000,"*A8*")
which also works fine. I cant seem to get the two to combine or find an alternative to what im trying to do which is get a range of dates between two points in coloumn G (lets say 15/01/2009 and 22/01/2009) and from that selection tell me how many of them rows contain the phrase "A8" in coloumn E. Iv tryed many different formulas and arrays but cant seems to get it right.
Any help would be much appreciated.