ExcelBanter - Formulas aveages in excel 2000

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formulas aveages in excel 2000 (https://www.excelbanter.com/excel-worksheet-functions/159237-formulas-aveages-excel-2000-a.html)

Robert N

Formulas aveages in excel 2000

Dumb question for you. But I am trying to find the right formula for this
problem. What i want is to add column D3 to D38. I want to find aveage of
all the $ amounts and divide it by how many people their are. I have d3 to
d38 as dollar amount and them find the total aveage. please help.

Rob

Teethless mama

Formulas aveages in excel 2000

=AVERAGE(D3:D38)

"Robert N" wrote:

Dumb question for you. But I am trying to find the right formula for this
problem. What i want is to add column D3 to D38. I want to find aveage of
all the $ amounts and divide it by how many people their are. I have d3 to
d38 as dollar amount and them find the total aveage. please help.

Rob

Robert N[_2_]

Formulas aveages in excel 2000

Thank You. aI knew it was that easy, but I had brain fart.

"Teethless mama" wrote:

=AVERAGE(D3:D38)

"Robert N" wrote:

Dumb question for you. But I am trying to find the right formula for this
problem. What i want is to add column D3 to D38. I want to find aveage of
all the $ amounts and divide it by how many people their are. I have d3 to
d38 as dollar amount and them find the total aveage. please help.

Rob

All times are GMT +1. The time now is 10:48 AM.