Using SUM to calculate values of cells containing formulae

  • Thread starter Thread starter jarwyn
  • Start date Start date
J

jarwyn

Hi

I'm new to this forum so "Hello" to everybody. I've had a look aroun
the forum but I can't seem to find the answer to my problem. I'm sur
it must be possible but I've tried everything I know short of writing
Macro. I hope one of you wonderful people will be able to help, I can'
believe I am the first person to come up against this problem

Here's the problem (somewhat simplified) ;

I have a column of cells containing the following formulae

Cell 1 (K2) =VLOOKUP(I2,$A2:$E34,5)
Cell 2 (K3) =VLOOKUP(I3,$A35:$E103,5)
Cell 3 (K4) =VLOOKUP(I4,$A104:$E176,5)

which looks up the value contained in cells I2, I3 & I4 and returns th
corresponding values from the range specified into cells K2, K3 & K4

So far so good - but now I want to total the 3 cells up i.e. K2 + K3
K4

If I use SUM it gives a value of 0 and most other things return a
error. I've tried various ways of converting the formula to a value b
adding INT, or by using CELL but nothing seems to work.

Please help as I am tearing my hair out, and I don't have much left!

Cheer
 
Hi

seems odd to me that this doesn't work .. what's actually in column E of the
range you're looking up to ... and what's its format (right mouse click on
it, choose format cells ... )
what's the format of cells K2, K3 & K4

Cheers
JulieD
 
Hi

Thanks JulieD

You saved my scalp ... when I checked the formatting it was set t
NUMBER with 1 decimal place and it looked like it was a value
couldn't see anything wrong with it ... but when I overtyped the valu
in the cell with the same value again ... it worked.

Don't know why it wasn't picking it up, all I can think is that
imported the values in from the Internet so it may have been som
hidden html formatting or something strange.

Anyway, many thanks ... and if you're in The Oak anytime, me and m
barber will buy you a drink.

Cheer
 
glad it's solved ... the way i'm feeling today i'll go to any expense to
find any pub anywhere :) ... directions please :)
 
LOL ... your day can't be that bad surely? The day is what you make o
it after all!!! Mind you, the old kareoke in the Oak can be a bit ba
at times. Turn right at Luton, turn left at Baldock and it's about th
3rd Pub on the right ... lol.

I'm struggling with another prob now ... to do with data tables an
combo boxes but I'll post it in a new thread. I used to know how to d
it in the good old days of Lotus 123 V1 ... lol ... now THAT was
spreadsheet!!

Cheers
:
 
Back
Top