Could someone please help me with a solution to my problem?

  • Thread starter Thread starter Eamon
  • Start date Start date
E

Eamon

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.
 
This is only or both columns or me

=SUMPRODUCT(('Cheltenham 1992-2010'!$X$2:$X$820<>"")*('Cheltenham
1992-2010'!$X$2:$X$820<=3)*('Cheltenham 1992-2010'!$Y$2:$Y$820<=3))

PS All I did was add a test for blanks as most of my test data was blank

HTH

Bob
 
Do you have empty cells which are being regarded as <=3 ?

Perhaps try =SUMPRODUCT(('Cheltenham
1992-2010'!$X$2:$X$820<=3)*('Cheltenham
1992-2010'!$Y$2:$Y$820<=3)*('Cheltenham
1992-2010'!$X$2:$X$820<>"")*('Cheltenham
1992-2010'!$Y$2:$Y$820<>"")) ?
 
Thank you Bob and David both your suggestions work perfect. Thanks again it
is very much appreciated.
 
Back
Top