Posted to microsoft.public.excel.misc

guitara

external usenet poster

Posts: 2

easier way to do this?

I have a column of numbers in A, and I want B1=average(A1:A10) ,
B2=average(A11:A20), B3=average(A21:30)..........................

Is there any way to do this calculation? I can not input each equation
in column B, since I have lots of data.

Can I set a function by myself?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
got to be an easier way?	redneck joe	Excel Discussion (Misc queries)	6	March 29th 06 02:56 AM
There's Got to be an Easier Way	Sprint54	Excel Discussion (Misc queries)	7	February 9th 06 12:06 AM
Is there an easier way?	wmaughan	Excel Discussion (Misc queries)	5	December 27th 05 10:56 PM
Easier Way?	scott45	Excel Worksheet Functions	2	October 12th 05 04:55 AM
There has to be any easier way!!	mully	New Users to Excel	18	August 13th 05 12:26 PM

All times are GMT +1. The time now is 02:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us