Excel equations

Hi, I’m felling my way around excel for the first time since high school.  I have the basic equations and averaging sorted but what I would like to do is have a line added up and averaged while igno...