Forum Discussion

GehrigSA's avatar
GehrigSA
Copper Contributor
Aug 07, 2023
Solved

Adding wins/Losses

I'm looking to add up all the wins and losses of games in a cell. The positive scores B4, C4, E4 are all winning game. While D4, F4 are losing games. So, I'm looking for a formula that shows the g...
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    Aug 07, 2023

    GehrigSA 

    Try this one:

     

    Games being B4:F4

     

    =COUNTIF(games,{">0","<0"})

     

Patrick2788's avatar
Patrick2788
Silver Contributor
Aug 07, 2023

GehrigSA 

Try this one:

 

Games being B4:F4

 

=COUNTIF(games,{">0","<0"})

 

GehrigSA's avatar
GehrigSA
Copper Contributor
Aug 07, 2023

Patrick2788 

 

Thanks it worked.

 

=COUNTIF(B4:F4,{">0"}) in Cell G4

=COUNTIF(B4:F4,{"<0"}) in Cell H4

 

Thanks