how to sum cells that already have formulas

[Guest]

I am using a lookup formula thats retrieves information from a list on a
different sheet. The RESULT i am getting is working. But when I try to use a
simple adding formula in another cell to add my RESULTS together I get an
error (VALUE!)
Can anyone help?

 

[Dave Peterson]

It sounds like the data you're returning is really text.

I think I'd try changing the base data to real numbers.

If you want to try, one quick way is to
copy an empty cell
select your range to convert
edit|paste special|check Add

Now '123 will be 123 (text vs numbers).

And your formula that adds should work ok.