AnsweredAssumed Answered

I/O timeout or #value datalink impact on calculations

Question asked by SaifGhadhban on Jan 10, 2016
Latest reply on Jan 13, 2016 by jaroberts

Hi,

 

I have a workbook that imports data with PI datalink, however sometimes we get I/O timeout or #value this effects all the formulas we have in the sheet such as average

 

Would it be possible to use averageif function if we have I/O timeout or #value errors for the following code?

 

Range("I7").Value = "=average(G4:G" & lastrow & ")"

 

I tired to add it to average values above zero however it didnt work

 

Range("I7").Value = "=averageif(G4:G" & lastrow & ",>0)"

Outcomes