Thread
:
VALUE ERROR
View Single Post
#
1
Posted to microsoft.public.excel.misc
ferde
external usenet poster
Posts: 87
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
Reply With Quote
ferde
View Public Profile
Find all posts by ferde