What to do when formula in Google Sheets is wrong?

In this case, the formula in the denominator SUM (A1:A7) evaluates to 0, which causes the error. So check whether your denominator result is 0. Next, check whether you have linked to blank cells or a blank range in your denominator. Then you can either fill in the blank cell or range, or select a different cell or range for your formula.
For More Information Please Refer:
You May Also Like to Read: