How to find the average of the annual salary using the month's salary in Excel?

Hi I need to find the the average annual salary using 开发者_开发技巧the salary per month data.

I know one can use another column for the salary per year and work it out, but I do not want to, since I am trying to make the application as efficient as possible.

Thanks

Maybe I'm misunderstanding what you're trying to achieve, but it looks like =SUM(B2:B4)*12/3 should do it. Or even better, =AVERAGE(B2:B4)*12, or =A7*12 since you already have the average number in its own cell.

Why are you asking this question, since the answer is quite clearly almost there in your screenshot?

You just need to put sum at the start.