|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 10th, 2006, 04:28 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
average
Hi, problem. a colum with numbers and formulas, what needs to be done to get the average of just the numbers col-1 col-2 col-3 5 5 10 5 20 30 sum 1+2 formulas sum 1+2 sum 1+2 sum 1+2 Average - I can not get the cell to show the average of 20 Tanks for you help Frank -- fwburkey ------------------------------------------------------------------------ fwburkey's Profile: http://www.excelforum.com/member.php...o&userid=30314 View this thread: http://www.excelforum.com/showthread...hreadid=499800 
|
|
#2
January 10th, 2006, 05:14 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
average
Is 20 supposed to be 25 If so =subtotal(1,c1:c2) change your range to the range you are trying to average. -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=499800
|
|
#3
January 10th, 2006, 07:17 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
average
keithl816 Wrote: =Average(c1:c2) change your range to the range you are trying to average. I am at the correct range, but everything that i try, i keep getting the error ( ( #DIV/0! ) -- fwburkey ------------------------------------------------------------------------ fwburkey's Profile: http://www.excelforum.com/member.php...o&userid=30314 View this thread: http://www.excelforum.com/showthread...hreadid=499800
|
|
#4
January 10th, 2006, 09:44 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
average
Can you post the formula you used? -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=499800
|
|
#5
January 12th, 2006, 02:18 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
average
1 2 3 a b 20 10 2 Formlar in cells are =b1/b2 c 50 5 10 =c1/c2 d #DIV/0! =d1/d2 e #DIV/0! =e1/e2 f #DIV/0! =f1/f2 average #DIV/0! ( I need this to be the avg of b3 thru f3) all i get for the avg is #DIV/0! Best i can do Thanks Again Frank -- fwburkey ------------------------------------------------------------------------ fwburkey's Profile: http://www.excelforum.com/member.php...o&userid=30314 View this thread: http://www.excelforum.com/showthread...hreadid=499800
|
|
#6
January 12th, 2006, 02:41 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
average
Hi
Change your formula in B3 to =IF(B2="","",B1/B2) Copy down Then =AVERAGE(B3:F3) -- Regards Roger Govier "fwburkey" wrote in message ... 1 2 3 a b 20 10 2 Formlar in cells are =b1/b2 c 50 5 10 =c1/c2 d #DIV/0! =d1/d2 e #DIV/0! =e1/e2 f #DIV/0! =f1/f2 average #DIV/0! ( I need this to be the avg of b3 thru f3) all i get for the avg is #DIV/0! Best i can do Thanks Again Frank -- fwburkey ------------------------------------------------------------------------ fwburkey's Profile: http://www.excelforum.com/member.php...o&userid=30314 View this thread: http://www.excelforum.com/showthread...hreadid=499800
|
|
#7
January 12th, 2006, 07:40 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
average
Roger, Thanks for the help, it has solved my problem.  Thanks Again Frank -- fwburkey ------------------------------------------------------------------------ fwburkey's Profile: http://www.excelforum.com/member.php...o&userid=30314 View this thread: http://www.excelforum.com/showthread...hreadid=499800
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| What is this kind of average called? | havocdragon | Worksheet Functions | 3 | June 24th, 2005 05:10 PM |
| Trying to Average an Average | Joe | Running & Setting Up Queries | 5 | April 4th, 2005 07:05 PM |
| Arrary formula for Average includes blank cells | jan | Worksheet Functions | 4 | May 14th, 2004 11:19 PM |
| Using array-entered formulas for calculation average | Kieran | Worksheet Functions | 4 | March 1st, 2004 04:00 AM |
| Problems using Average | MeritageSue | Worksheet Functions | 3 | February 1st, 2004 02:48 AM |
Linear Mode
