Forum Discussion
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 StableFordFunc!B27:StableFordFunc!M51 ranks the final scores from largest to smallest. Once it reaches the final score though it creates either a N/A error or DIV/0 Error. Ive attached the sheet below. If you could take a look id apprecate it.
1 Reply
Thomas, use same range
1/COUNTIF(B$2:B$26,$B$3:$B$26) => 1/COUNTIF(B$2:B$26,$B$2:$B$26)
