formula VALUE error
 

=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

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

"Micayla Bergen" wrote in message
...
=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

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

"Biff" wrote:

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

"Micayla Bergen" wrote in message
...
=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

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 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 :-)
------------------------------*------------------------------*----------------


"Micayla Bergen" wrote in message
...
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

"Biff" wrote:

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

"Micayla Bergen" wrote in
message
...
=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