I’m averaging 3 columns, all rollups. Note that I have this formula in them, so certain cells are blank: IF(ISERROR(AVERAGE(values))=0,AVERAGE(values),BLANK()) The 4th column, where I want to average THOSE columns, has NaN if all 3 columns are blank....

Hey folks - can’t seem to find this in the forum. We have an Overview table that has records that correspond to dates - every month for each year (say 2019 and 2020). In another table, we have a Linked Record column, where one can select which Overvi...