gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 684
- Office Version
- 2019
- Platform
- Windows
Hello,
Want to know why its not showing as a formula.
And the formula is changing when copy/pasted in this window?
Want to know why its not showing as a formula.
And the formula is changing when copy/pasted in this window?
Wagers.xlsm | |||||||
---|---|---|---|---|---|---|---|
O | P | Q | R | S | |||
18 | Bets | Team | W | L | W % | ||
19 | 0 | IFERROR(LOOKUP(2, 1/((COUNTIF($H$520:$H520,[NBA.xlsm]Favs!$H$4:$H$33)=0)*([NBA.xlsm]Favs!$H$4:$H$33<>"")),[NBA.xlsm]Favs!$H$4:$H$33),"") | 0 | 0 | |||
20 | 2 | TOR | 1 | 1 | 50% | ||
21 | 1 | SAN | 0 | 1 | 0% | ||
22 | 9 | MIA | 4 | 5 | 44% | ||
23 | 8 | PHX | 5 | 3 | 63% | ||
24 | 6 | UTA | 5 | 1 | 83% | ||
NBA |
Cell Formulas | ||
---|---|---|
Range | Formula | |
O19:O24 | O19 | =Q19+R19 |
P19:P24 | P19 | =IFERROR(LOOKUP(2, 1/((COUNTIF($P$18:P18,$H$175:$H$825)=0)*($H$175:$H$825<>"")),$H$175:$H$825),"") |
Q19:Q24 | Q19 | =COUNTIFS($A$175:$A$825,"W",$H$175:$H$825,$P19) |
R19:R24 | R19 | =COUNTIFS($A$175:$A$825,"L",$H$175:$H$825,$P19) |
S19:S24 | S19 | =IFERROR(Q19/(Q19+R19),"") |
Last edited: