completely lost

[clueless]

Hi folks,

I am someone who uses computers mainly for email. However, I just started working on a project (it will last for a year) that requires more.

I am expected to take raw data and complie it in a manner to be appropriate for publication in professional journals.

I was sent a bunch of excell spreadsheets with the numbers. But I need to add them up and then take an average.

I have no idea how to get excell to do this. I used to have a book but I don't have that book any more. The help function in excell is no help..I can never find what I need. I did find something that looked like you should write =SUM and then list the cells, but I did that and got #Name in that cell.

Will somebody out there help me please?

[BenjieLop]

Hi folks,

I am someone who uses computers mainly for email. However, I just started working on a project (it will last for a year) that requires more.

I am expected to take raw data and complie it in a manner to be appropriate for publication in professional journals.

I was sent a bunch of excell spreadsheets with the numbers. But I need to add them up and then take an average.

I have no idea how to get excell to do this. I used to have a book but I don't have that book any more. The help function in excell is no help..I can never find what I need. I did find something that looked like you should write =SUM and then list the cells, but I did that and got #Name in that cell.

Will somebody out there help me please?

If your numbers are in, say, Cells A1:A100, then the sum is

=sum(A1:A100)

and the average is

=average(A1:A100)


In the absence of a book, you can check the following sites for excellent Excel tips/techniques:

http://www.datapigtechnologies.com/ExcelMain.htm
http://www.contextures.com/tiptech.html
http://www.cpearson.com/excel/topic.htm
http://www.mrexcel.com

Hope this helps you.

Regards.

[Tom Ogilvy]

Why not request that your employer send you to training to get the requisite
skills for the assignment. A little bit of training may go a long way in
producing a better product in a short amount of time.

Assume the data is in cells B2:B30

in B31 put in

=Average(B2:B30)

If you actually need a sum as well

=Sum(B2:B30)

the notation B2 refers to the cell at row 2 and column B. likewise, B30
refers to the cell at row 30 and column B. when written as B2:B30, it means
all the cells between and including those cells in rows 2 through 30 in
column B.

--
Regards,
Tom Ogilvy


"clueless" <[email protected]> wrote in
message news:[email protected]...
>
> Hi folks,
>
> I am someone who uses computers mainly for email. However, I just
> started working on a project (it will last for a year) that requires
> more.
>
> I am expected to take raw data and complie it in a manner to be
> appropriate for publication in professional journals.
>
> I was sent a bunch of excell spreadsheets with the numbers. But I need
> to add them up and then take an average.
>
> I have no idea how to get excell to do this. I used to have a book but
> I don't have that book any more. The help function in excell is no
> help..I can never find what I need. I did find something that looked
> like you should write =SUM and then list the cells, but I did that and
> got #Name in that cell.
>
> Will somebody out there help me please?
>
>
> --
> clueless
> ------------------------------------------------------------------------
> clueless's Profile:
http://www.excelforum.com/member.php...o&userid=25102
> View this thread: http://www.excelforum.com/showthread...hreadid=386100
>

[Bernard Liengme]

Why not go to public library and get a simple book; or visit a bookshop and
shell out a few bucks to get you started.
Carpe diem
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"clueless" <[email protected]> wrote in
message news:[email protected]...
>
> Hi folks,
>
> I am someone who uses computers mainly for email. However, I just
> started working on a project (it will last for a year) that requires
> more.
>
> I am expected to take raw data and complie it in a manner to be
> appropriate for publication in professional journals.
>
> I was sent a bunch of excell spreadsheets with the numbers. But I need
> to add them up and then take an average.
>
> I have no idea how to get excell to do this. I used to have a book but
> I don't have that book any more. The help function in excell is no
> help..I can never find what I need. I did find something that looked
> like you should write =SUM and then list the cells, but I did that and
> got #Name in that cell.
>
> Will somebody out there help me please?
>
>
> --
> clueless
> ------------------------------------------------------------------------
> clueless's Profile:
> http://www.excelforum.com/member.php...o&userid=25102
> View this thread: http://www.excelforum.com/showthread...hreadid=386100
>

[Debra Dalgleish]

In addition to the other excellent suggestions, David McRitchie has a
list of Excel online tutorials:

http://www.mvps.org/dmcritchie/excel....htm#tutorials


clueless wrote:
> Hi folks,
>
> I am someone who uses computers mainly for email. However, I just
> started working on a project (it will last for a year) that requires
> more.
>
> I am expected to take raw data and complie it in a manner to be
> appropriate for publication in professional journals.
>
> I was sent a bunch of excell spreadsheets with the numbers. But I need
> to add them up and then take an average.
>
> I have no idea how to get excell to do this. I used to have a book but
> I don't have that book any more. The help function in excell is no
> help..I can never find what I need. I did find something that looked
> like you should write =SUM and then list the cells, but I did that and
> got #Name in that cell.
>
> Will somebody out there help me please?
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html