Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Could someone please help me with a solution to my problem?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Could someone please help me with a solution to my problem?
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 "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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Could someone please help me with a solution to my problem?
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<"")) ? -- David Biddulph "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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
any solution to slash problem | Excel Discussion (Misc queries) | |||
OLD PROBLEM without SOLUTION | Excel Worksheet Functions | |||
OLD PROBLEM without SOLUTION , part || | Excel Worksheet Functions | |||
Need A Solution To A Problem | Excel Discussion (Misc queries) | |||
Need solution to formula problem | Excel Discussion (Misc queries) |