Help with MS Excel

Sun Tzu · 02-06-2004, 05:13 PM

Real quick like.

I'm trying to figure out how to find an average $$$ amount out of about 200 seperate figures. The thing is they are not all in a row. They are all in seperate areas in the spreadsheet. Like say an average of the numbers in G10:G69 AND G113:G210 AND etc... How would I go about doing this? I have tried a couple different ways and I just keep getting error messages. Any and all help is greatly appreciated.

Buccaneer · 02-06-2004, 05:32 PM

Just set up the forumula from the function list

=AVG(

or is it =AVERAGE(

then using the Ctrl button, just highlight all of the cells you want averaged. Excel will provide the right notation. Just don't forget the end parenth.

Sun Tzu · 02-06-2004, 05:45 PM

Thanks. Aparently I was just entering too many "Arguements". However I was able to find a way to work around it.

02-06-2004, 05:32 PM	#2
Buccaneer Head Coach Join Date: Oct 2000 Location: Colorado	Just set up the forumula from the function list =AVG( or is it =AVERAGE( then using the Ctrl button, just highlight all of the cells you want averaged. Excel will provide the right notation. Just don't forget the end parenth. Last edited by Buccaneer : 02-06-2004 at 05:33 PM.

02-06-2004, 05:45 PM	#3
Sun Tzu Pro Starter Join Date: Dec 2003 Location: In the thick of it.	Thanks. Aparently I was just entering too many "Arguements". However I was able to find a way to work around it. __________________ I'm still here. Don't touch my fucking bacon.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)