Thread: average
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
fwburkey
 
Posts: n/a
Default 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