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

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