I apologize in advance as I know this has been asked and solved multiple times but I can't seem to figure it out.
I have totaled (sum) of numerous rows that I would like to average, and to do so I need to remove the zeros. I am struggling with the "If" formula.
Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!