I have several pieces of data on another spreadsheet and I need excel to look up and average data with the same name. I need to put an ISerror in this function, but I get too a too many arguments error. I'm not sure if there is a simpler way to write to following formula so I can use an ISerror?
{=AVERAGE(IF('Sheet XYZ'!$B$2:$B$669=AG11,IF('Sheet XYZ'!$F$2:$F$669>0,'Sheeet XYZ'!$F$2:$F$669)))}
Bookmarks