External Data
Hi John
One way
=IF(COUNT(E4:E5)<2,"",AVERAGE(E4:E5))
--
Regards
Roger Govier
"John" wrote in message
...
Can anyone help i have set up a spreadsheet that update every 1 minute
form a
data base but when i am trying to do a Average formula between to
cells that
contain call stats it cums up with the #DIV/0! in the cell were it
should be
a average of calls across the two cells this is the formula i am
using -
=AVERAGE(E4:E5)
does anyone now a formula that can read off the external data after it
has
imported into excel
the only formula that i can get working is =E4:E5 insted of a
=SUM(E4:E5)
Please can someone help !!!
|