Thread: VALUE ERROR
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ferde ferde is offline
external usenet poster
 
Posts: 87
Default VALUE ERROR

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