average formula

samanthaG

New Member
Joined
Nov 14, 2005
Messages
4
I know this as probably been asked but I thought that it might be easier to ask again then to read every post. I'm new to excel.

I want to have an average at the end of a row of percentages and I know how to do just one row at a time but how do I do all the rows at one time?

Thank you for your time.

Samantha
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,454
Office Version
  1. 365
Platform
  1. Windows
Do you mean you want to average EACH row individually, or get an average of all the rows combined together?

If each row, simply do your first formula and copy it down for all rows.
If everything combined, just include the entire range in your formula.
 

samanthaG

New Member
Joined
Nov 14, 2005
Messages
4
Thank you, I knew it had to be easy. I will use this message board often, I can tell.

Samantha
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,454
Office Version
  1. 365
Platform
  1. Windows
Your welcome! Use us, we are here at your disposal.

And welcome to the board!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,736
Messages
5,573,921
Members
412,555
Latest member
mark84
Top