formula VALUE error

M

Micayla Bergen

=SUM(('A & E John Super'!$L$3:$L$38)+('A & E John Super'!$P$3:$P$38))/('A & E
John Super'!$K$3:$P$38)

i dont know why this isnt working. im sure its extremely simple but i cant
see for looking
thanks anyone
 
B

Biff

Hi!

Hard to tell what you're trying to do!

Try this and see if you get what you expect (basically, this is my best
guess):

=SUM('A & E John Super'!$L$3:$L$38,'A & E John Super'!$P$3:$P$38)/SUM('A & E
John Super'!$K$3:$P$38)

Biff
 
M

Micayla Bergen

hi biff
have changed the formula to
=SUM('A & E John Super'!$L$3:$L$38,'A & E John Super'!$P$3:$P$38)/('A & E
John Super'!$K$3:$P$38)
but w the same result.
basically columns L - P have dollar amounts, and i want the sum of column L
and P be be dividied the whole L - P
thanks
 
K

Ken Wright

basically columns L - P have dollar amounts, and i want the sum of column
L
and P be be dividied the whole L - P
Click to expand...

Not sure where column K comes into it given your text, but try this:-

=SUM('A & E John Super'!$L$3:$L$38,'A & E John Super'!$P$3:$P$38)/SUM('A & E
John Super'!$L$3:$P$38)

This sums L3:L38 and P3:p38 and divides by the whole of L3:p38, ie including
M and N and O

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :)
------------------------------­------------------------------­----------------
 
Top