I want to average 3 non-consecutive cells that are populated due to a link from another worksheet. One of the 3 cells may have a #div/0! value and therefore the average calculation results in a #Div/0! I have tried average, averageif & averageifs. Need help
Ross indelicato