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 game in Cells G4 and H4

Kevin should have a 3-2 record after 5 games and a running total of -4 (I4)

 

 

    • GehrigSA's avatar
      GehrigSA
      Copper Contributor

      Patrick2788 

       

      Thanks it worked.

       

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

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

       

      Thanks

Resources