External Data
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 !!! |
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 !!! |
All times are GMT +1. The time now is 07:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com