Excel Help Please

[white17]

I have a column of numbers in an excel sheet. I have figured everything I want except the "mean" and can't find the correct function command. Anyone help? TIA

 

[zentrader]

=average(a:a) or whatever your column is

 

[white17]

ZT: Thank you !

 

[vladiator]

Quote from white17:

ZT: Thank you !

summing the numbers up and dividing by N would have worked too LOL. Just kidding.

 

[white17]

I broke down and used the AVERAGE Fx.

 

[big_jdez]

I'm looking to create a real time spreadsheet. I have AT which has a nice DDE link, however I don't know how to create new rows every 5 minutes so I can calculate formulas. I also need help creating an alarm of some sort.

Does anyone have something similiar already that they might want to sell?