Sep 22 2021 07:35 AM
Hello, Need formula excel to count of winning games, for example 13-2, 3-13, and 13-8 games won is 2. Thank you for the correct formula. Cell ranges are D3 tot N3 Gr Henk
Sep 22 2021 07:59 AM
As an array formula confirmed with Ctrl+Shift+Enter:
=SUMPRODUCT(--(IFERROR(LEFT(D3:N3,SEARCH("-",D3:N3)-1)-MID(D3:N3,SEARCH("-",D3:N3)+1,10),0)>0))
Sep 22 2021 10:49 AM - edited Sep 22 2021 10:51 AM
That will work if a game/match is always won by reaching 13 points. The formula that I posted is more general, it also works for football games or baseball games.
Sep 22 2021 11:25 AM