Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I prevent the "division by zero" error in this formula | Excel Worksheet Functions | |||
Formula syntax error - chinese and gibberish | Excel Discussion (Misc queries) | |||
Formula error... | Excel Discussion (Misc queries) | |||
Formula Error | Excel Discussion (Misc queries) | |||
Formula MATCH error | Excel Worksheet Functions |