completely lost

  • Thread starter Thread starter clueless
  • Start date Start date
C

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?
 
clueless said:
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?
Click to expand...


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.
 
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.
 
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
 
Back
Top