How do you ignore zeros when averaging data not next to each other.

[Nothnless]

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.

 

[Joe4]

Would you ever be excluding A2, D2, and G2 if one of those was zero?
If not, one way is to do averages the old fashioned way, i.e.
=(A2+D2+G2)/3

 

[Nothnless]

Hi, Yes.

I found my answer but thanks for the help.

Note to future self: =(A2+D2+G2) / ((A2<>0)+(D2<>0)+(G2<>0))

 

[Joe4]

Hi, Yes.

I found my answer but thanks for the help.

Note to future self: =(A2+D2+G2) / ((A2<>0)+(D2<>0)+(G2<>0))

Ah, OK. I wasn't sure if these zeroes where in those columns, or the other columns you didn't want to include.
Glad you got it figured out.