Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
List of excel 2000 formulas Josh Excel Worksheet Functions 2 August 24th 06 05:28 PM
Excel 2000 - Formulas and Functions DeeW Excel Discussion (Misc queries) 4 August 10th 06 07:00 PM
where can i find Formulas for excel 2000? Mrs.S.Paul Excel Worksheet Functions 1 February 24th 06 12:35 PM
Get aveages for last few days Sick Puppy Excel Worksheet Functions 15 June 23rd 05 06:06 PM
Hiding formulas in Excel 2000 HarryMangurian Excel Discussion (Misc queries) 1 May 17th 05 12:29 PM


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"