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

VALUE ERROR
 

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

VALUE ERROR
 

Yes it works perfect,


Thank you, Thank you, Thank you



"JLatham" wrote:

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

VALUE ERROR
 

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

"ferde" wrote:

Yes it works perfect,


Thank you, Thank you, Thank you



"JLatham" wrote:

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

VALUE ERROR
 

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" wrote:

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

"ferde" wrote:

Yes it works perfect,


Thank you, Thank you, Thank you



"JLatham" wrote:

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

VALUE ERROR
 

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(H30,I2+H3,I2) at I3 and fill it on down the
sheet.



"Mykull" wrote:

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" wrote:

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

"ferde" wrote:

Yes it works perfect,


Thank you, Thank you, Thank you



"JLatham" wrote:

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