#VALUE

tamrob23

Board Regular
Joined
Jun 20, 2006
Messages
203
Good Afternoon,

I have a spreadsheet and I'm just adding 2 columns(=g5+g6), it is coming back #VALUE. I've tried putting it on another spreadsheet and I keep getting the same thing. Please help....
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Doug.T

Board Regular
Joined
Sep 19, 2006
Messages
80
I suspect that one of the cells has is not blank but has a space in it.

Wrap a SUM around your formula ie: =sum(g5+g6). that should return a valid number.
 

tamrob23

Board Regular
Joined
Jun 20, 2006
Messages
203
Hi Doug T.

Yes one of the cells are blank and the other space has a number in it.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
Hi Doug T.

Yes one of the spaces are blank and the other space has a number in it.

=TRIM(G5)+TRIM(G6)

will probably work. However, try to remove the space char(s) if any from G5 and G6, so that simple

=G5+G6

can succeed.
 

tamrob23

Board Regular
Joined
Jun 20, 2006
Messages
203

ADVERTISEMENT

The trim did not work. Attached is a pice of my spreadsheet. Where the cell is blank is a formula and on the side I have were the cell is blank and that there is a "1", which is coming from another formula.
QA Review (2).xls
DEFG
49Feb  
50#VALUE!Mar11
II-5
 

tamrob23

Board Regular
Joined
Jun 20, 2006
Messages
203

ADVERTISEMENT

I tried that and it worked! Is it because "=" is so broad that Excel was getting confused??
QA Review (2).xls
DEFG
49Feb  
501Mar11
II-5
 

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
I tried that and it worked! Is it because "=" is so broad that Excel was getting confused??
QA Review (2).xls
DEFG
49Feb  
501Mar11
II-5

Sum() ignores the non-numerical cell values.... just using a + argument doesn't.
 

tamrob23

Board Regular
Joined
Jun 20, 2006
Messages
203
As always NBVC, you rock!! Thank you for explaining that to me. Have a great afternoon =0)
 

Forum statistics

Threads
1,144,364
Messages
5,723,937
Members
422,527
Latest member
TotalBeginner201

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top