Could someone please help me with a solution to my problem?
Thank you Bob and David both your suggestions work perfect. Thanks again it
is very much appreciated.
"Eamon" wrote in message
...
Could someone please help me with a solution to my problem...?
In column X I have finishing position last run
In column Y I have finishing position penultimate run
What I am trying to do is find how many times the finishing position in
both the last run and penultimate run was 1st 2nd or 3rd
I have been trying this formula...
=SUMPRODUCT(('Cheltenham 1992-2010'!$X$2:$X$820<=3)*('Cheltenham
1992-2010'!$Y$2:$Y$820<=3)) but it appears to be returning all instances
of finishing position equal or less that three, where I only want it to
return when the finishing position is equal or less than three, in both
column X and Y
Any suggestions with formula to accomplice this would be most welcome.
Thank you.
|