Faseeh
Excel Ninja
Thank you for the compliments, you will find threads longer then this one on this forums. I tried to understand the problem to my level best but sometimes things are not that straight.
Ok now i have understood that there are 9 columns between Column C to Column K and these columns Correspond to the 9 columns of P to X? I hope this is correct. Further that you want to go column wise. i.e we need to ignore the no. of rounds here. just do every calculation column wise. since there are 9 columns between c to k, the produced result will be placed in the corresponding 9 columns between p to x? Hopefully this should also be correct. If yes then what you want is..
Check if C4=1, then C3*C4
Check if C9=1, then C9*C8
Check if C14=1, then C14*C13
...and so on till the end of column c.
if this description is correct then [considering only first two round, because it will let me examine lesser no. of rows while debugging formula] the formula that needed to be placed in cell P20 is:
=SUM(IF(IF($B$2:$B$10="GIR",C$2:C$10)=1,C$2:C$10)*($B$1:$B$9="PUTTS")*(C$1:C$9<>"")*1)
please see the attached file, and let me remind you again that you have explained things but not provided me with the manually calculated correct answer of the question!!
Ok now i have understood that there are 9 columns between Column C to Column K and these columns Correspond to the 9 columns of P to X? I hope this is correct. Further that you want to go column wise. i.e we need to ignore the no. of rounds here. just do every calculation column wise. since there are 9 columns between c to k, the produced result will be placed in the corresponding 9 columns between p to x? Hopefully this should also be correct. If yes then what you want is..
Check if C4=1, then C3*C4
Check if C9=1, then C9*C8
Check if C14=1, then C14*C13
...and so on till the end of column c.
if this description is correct then [considering only first two round, because it will let me examine lesser no. of rows while debugging formula] the formula that needed to be placed in cell P20 is:
=SUM(IF(IF($B$2:$B$10="GIR",C$2:C$10)=1,C$2:C$10)*($B$1:$B$9="PUTTS")*(C$1:C$9<>"")*1)
please see the attached file, and let me remind you again that you have explained things but not provided me with the manually calculated correct answer of the question!!