Excel question......?

Question

I have a cell that I am trying to put a sum in, ex A1+A2 etc, but when I get to the cell that I want the answer in it says VALUE as the error. I can't figure out what I am doing wrong. Thanks.

=(K7+I7+G7+E7)

This is what I put and I still get the value error!

Answer 1

Don't forget the = sign! If you are getting the #VALUE error, you almost certainly left it out.

In the cell that you want the answer, put =A1+A2. You can add the contents of a range, for example A1 to A5, using =SUM(A1:A5). That is useful when you need to insert or delete rows from your column because the function SUM automatically updates. If you just want to add the contents of two cells, it's better to use the formula, on the whole.

Answer 2

You might be entering the wrong formula. Click the box you want the total to be in then you have to put a formula.
If you want an entire row its =SUM(A1:A3) You write the beginning of the row until the end.

If you want specific columns its =SUM(A1,A2,A3) You write each column individually with a comma.

Answer 3

There is nothing wrong with your formula itself, the most likely problem is that one or more of the cells you are trying to sum is either a non-numeric value or is not formatted as a number.

Answer 4

**********************************************
If you have used the right formula, ie =A1+A2 [or =Sum(A1:A2)], and you are still getting the #Value as the result, it means that one or both of the cells (ie A1 or/and A2) contain a non-numeric value. The + sign may be used only with numbers, if one of the values is text or a symbol the result of addition will give you #Value error.
**********************************************

Answer 5

First, try a different cell

Second try using the = sign first e.g. =a1+a2

Answer 6

I work with Excel everyday and sometimes it can be tricky. Sometimes you can save your work and close the program, then re-enter it again, and it will work fine. It's worth a try.

Also, if the number you are trying to enter is too large to fit in the cell, you may need to widen the column.

Answer 7

Make sure what you're trying to sum is formatted as a number.

Answer 8

are you putting an "=" in front of A1+A2?

Answer 9

if you are using sum the notation is:

sum(a1:a2)

Answer 10

try this: in your {value-error} cell:

select it, and then right click,

select {Format Cells...}

At the first tab, {Numbers} tab,

select {Number} instead of {General}.

click on {OK} and try again.

.. let us know if anything worked for you ...

(also your cell might simply be needing more space, simply select the entire column from above and drag its right margin for more width)

Cheers.