Hi, I know this works =AVERAGEIF(A2:G2,"<>0")
But how do I do the same thing if I only want to look at values in specific columns? A2, D2, G2, assuming there are other numbers I don't want included in the average in between these columns.
But how do I do the same thing if I only want to look at values in specific columns? A2, D2, G2, assuming there are other numbers I don't want included in the average in between these columns.