Front Office Football Central

Front Office Football Central (https://forums.operationsports.com/fofc//index.php)
-   FOFC Archive (https://forums.operationsports.com/fofc//forumdisplay.php?f=27)
-   -   Help with MS Excel (https://forums.operationsports.com/fofc//showthread.php?t=21288)

Sun Tzu 02-06-2004 05:13 PM

Help with MS Excel
 
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. :)


All times are GMT -5. The time now is 04:53 PM.

Powered by vBulletin Version 3.6.0
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.