VALUE ERROR

[Guest]

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

 

[Guest]

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

 

[Guest]

Yes it works perfect,


Thank you, Thank you, Thank you

 

[Guest]

You are welcome, thanks for the feedback and for letting me know it solved
your problem.

 

[Mykull]

JLatham...I hope you can help me also.

F G H I J
Expense Date Amt Cumulative Whats Left
2 Gas 05/01/09 $21.26 $21.26 $641.00
3 Cash 05/04/09 $102.00 $123.26 $539.00
4 Gas 05/04/09 $24.74 $148.00 $514.26
5 #VALUE!
6 #VALUE!



The formula I have in J2 is simply 662.26-I2
The long version = I just want column J to continuously subtract the column
I starting with 662.26 as a balance. Its working fine I just want get rid of
the #VALUE that is displayed all the way down the page in column J.

 

[JLatham]

Then in J3 I would put
=J2 - H3
and fill it on down the worksheet. That should not display any #VALUE!
errors, it will simply show the last balance/what's left at the last expense
row on down the sheet and update as more expenses are added in column H.
To add more money to the account, put a negative number into column H.

Just as an added note, the formula in I3 should be: =I2+H3 or, to keep from
including added deposits entered into column H to the cumulative expense
column (I), use this formula =IF(H3>0,I2+H3,I2) at I3 and fill it on down the
sheet.