Change your formula to:
=IF(G2=0,"",SUM(G3:G4)/G2)


"ferde" wrote:

E F G H
1 Jan-Mar April-Jun Jul-Sep Oct-Dec
2 1 1 1 1
3 0 1 1 0
4 1 0 1 1
5 100% 100% #VALUE! 100%

I am trying the following formula=IF(COUNT(G2=0,""),SUM(G3:G4/G2))

I need help tyring to figure out why I'm getting the VALUE error