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

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

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

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

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

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