formula VALUE error

[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

[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

"Micayla Bergen" <[email protected]> wrote in message
news:[email protected]...
> =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

[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

"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" <[email protected]> wrote in message
> news:[email protected]...
> > =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
>
>
>

[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 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in
>> message
>> news:[email protected]...
>> > =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
>>
>>
>>