Forum Discussion
GehrigSA
Aug 07, 2023Copper Contributor
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)
2 Replies
Sort By
- Patrick2788Silver Contributor
- GehrigSACopper Contributor
Thanks it worked.
=COUNTIF(B4:F4,{">0"}) in Cell G4
=COUNTIF(B4:F4,{"<0"}) in Cell H4
Thanks