External Data

[John]

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 !!!

 

[Roger Govier]

Hi John

One way
=IF(COUNT(E4:E5)<2,"",AVERAGE(E4:E5))