I get a #VALUE! msg.

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Hello,

I'm adding two columns,
first- A7:A125 with the formula in A126
second- E7:E125 with the formula in E126

Then I divided the results for a percentage in a cell at the top E3.

First question: Can I do this: =SUM(E7:E125)/(A7:A125) I mean obviously I
can't because I get this error/if I can it will save me a bit of work... am
I missing something?

Second question: cell A126 has a total that I want to use in every calc as I
copy it from E3 to F4 etc....

Regards,
Kevin
 
One way:

=SUM(E7:E125)/SUM(A7:A125)


Second question: Take a look at "the difference between absolute and
relative references" in XL Help. For example:

E3: =E1/$A$126

when copied to F4 becomes:

F4: =F2/$A$126
 
Hi JE,

That was it... thanks... I forgot about the $ thingy.... works like a
charm eh...

ty,
Kev
 
Back
Top