Calculate Win/Loss rate from two columns. One Wins, One Losses

[FXA]

I figured out how to make this work for a single column but now I need to calculate the Win/Loss rate from two different columns. One for Wins, One for losses

I tried the following and it did not work:

=IFERROR( (COUNTIF(J$5:J$157,D$5:D$157">0"))/SUM(--(J$5:J$157,D$5:D$157<>"")), "")

Original code for a single column calculation

Wins:

=IFERROR( (COUNTIF(D$5:D$157,">0"))/SUM(--(D$5:D$157<>"")), "")

Losses:

=IFERROR( (COUNTIF(D$5:D$157,"<0"))/SUM(--(D$5:D$157<>"")), "")

 

[Alex Blakenburg]

See if this works for you:

=IFERROR(SUM(--(J$5:J$157>0),--(D$5:D$157>0))/SUM(--(J$5:J$157<>""),--(D$5:D$157<>"")),"")

 

[FXA]

See if this works for you:

=IFERROR(SUM(--(J$5:J$157>0),--(D$5:D$157>0))/SUM(--(J$5:J$157<>""),--(D$5:D$157<>"")),"")

Thank you, this works exactly as intended!

 

[Alex Blakenburg]

Thanks for letting me know. Glad I could help.

 

[FXA]

Thanks for letting me know. Glad I could help.

You guys/this forum have been so much help and I appreciate it. It has been years since I have had to create in excel and the knowledge has partly gone to the wayside. So thank you.