formula VALUE error

[Guest]

=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

 

[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

 

[Guest]

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

 

[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

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 P338 and divides by the whole of L338, 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
------------------------------­------------------------------­----------------