Forum Discussion
Thomas Bryant
Sep 26, 2017Copper Contributor
N/A And DIV/0
Ive been working on a scoreboard. So when you enter data into StableFordInput!B2:StableFordInput!M26 it should calculate the scores and display them in StableFordFunc!B3:StableFordFunc!M26. Finally ...
SergeiBaklan
Sep 26, 2017Diamond Contributor
Thomas, use same range
1/COUNTIF(B$2:B$26,$B$3:$B$26) => 1/COUNTIF(B$2:B$26,$B$2:$B$26)