Need help w/ adding cells and dividing SUM by number of cells

[lnbegin]

Hey guys and gals,
I'm a Dummy user. I'm drawing a blank on how to do a simple formula. I want
to add several cells in a column and what ever the sum is I want to be able
to divide it by the number of cells I added. For example, I'm wanting to
return of percentage of work complete. So if I have 8 of 10 items 100%
complete and I want to figure out what the total completion percentage is I'd
want to 8 cells of 100 and 2 cells of 0 and then divide it by 10. How would
the formula look?

 

[Gav123]

Hi,

Format the cell where you want the result to Percentage (Format>Format
Cells> Number tab> Percentage) then type..

=AVERAGE(A1:A10)

Change A1:A10 to your own range.

Hope this helps

Regards,

Gav.

 

[lnbegin]

Gav,
I tried that and I still got the response #DIV/0. I'm trying to add two 100%
and two 0% to get a 50% answer. Thank you for the help. If you have any other
suggestions please let me know.

 

[Bob Phillips]

=AVERAGE(A1:A10)

and format as a percentage

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gav123]

Is your data set out something like this..

A1 100%
A2 100%
A3 0%
A4 0%

If not can you please try to show how it is set out?

If you use the average function on the example data above you get an answer
of 50%.

Regards,

Gav.