Hello,
I am new to this site and need help with a problem I am having on Excel.
I am trying to count the number of cells in column Q that have a "Y" in it,
provided that the date in column A is between 27/02/10 and 06/03/10. Does
this make sense??
I have tried;
=SUMPRODUCT((A14:A1000<="06/03/10")*(A14:A1000="27/02/10")*(Q14:Q1000="Y"))
but this just returns a 0.
Can anybody help please?