Thread Tools Rate Thread

# formula average

=?Utf-8?B?TWVsbGU=?=
Guest
Posts: n/a

 6th Oct 2005
Hi,

I have in column A valuea (numbers in A1:A1000). I want to compute the
average of the numbers in cells A10:A20:A30:A40 etc... etc... A990:A1000.

Does someone know a formula for this problem. Manually is too much work.

=?Utf-8?B?QW5pcnVkaA==?=
Guest
Posts: n/a

 6th Oct 2005
Hi melle,

pls try this
=average(cell ref)

anirudh

"Melle" wrote:

> Hi,
>
> I have in column A valuea (numbers in A1:A1000). I want to compute the
> average of the numbers in cells A10:A20:A30:A40 etc... etc... A990:A1000.
>
> Does someone know a formula for this problem. Manually is too much work.

Jerry W. Lewis
Guest
Posts: n/a

 6th Oct 2005
Why do you keep asking the question if you are going to ignore the
answers? If you don't understand the answers you have already received
to your previous posts, reply back to the answer requesting
clarification instead of repeating the same question over and over again.

Jerry

Melle wrote:

> Hi,
>
> I have in column A valuea (numbers in A1:A1000). I want to compute the
> average of the numbers in cells A10:A20:A30:A40 etc... etc... A990:A1000.
>
> Does someone know a formula for this problem. Manually is too much work.

melle
Guest
Posts: n/a

 6th Oct 2005

I am sorry. In the future I willp ost my questions only once.

--
melle
------------------------------------------------------------------------
melle's Profile: http://www.excelforum.com/member.php...o&userid=26981
View this thread: http://www.excelforum.com/showthread...hreadid=473716

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post DonFlak@gmail.com Microsoft Excel Worksheet Functions 2 31st Jan 2008 09:28 PM =?Utf-8?B?cGhzaGlyaw==?= Microsoft Excel Worksheet Functions 4 14th Apr 2005 01:20 AM =?Utf-8?B?Sm9l?= Microsoft Access Queries 5 4th Apr 2005 07:05 PM Blewyn Microsoft Excel Misc 3 12th Nov 2004 03:03 PM Niki Odolphi Microsoft Excel Programming 5 20th Mar 2004 11:11 PM

Features

Advertising

Newsgroups

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