Forum Discussion
Need formula
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
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))