LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 2
Default AVERAGE formula covering a date range

I am currently using the formula to calculate the average of a group of numbers listed in a worksheet. Withinin the worksheet is my number and a date. I want to adjust the formula so that it calculates the average for each month. I know each month will need a separate formula which is fine.

=AVERAGE('Asset Finance'!$O3:$O65536)

Thanks
 
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
Average a group of numbers within an date range. sross Excel Worksheet Functions 4 April 22nd 09 11:16 PM
Average values in date range sarahg Excel Worksheet Functions 5 September 15th 08 04:31 PM
select date range then find average of values in another cell rob117 Excel Worksheet Functions 3 May 3rd 07 03:34 PM
Basing Average function range on Date? DangerMouse Excel Discussion (Misc queries) 4 June 20th 06 06:21 PM
Formula bar covering column headers Hanr3 New Users to Excel 2 June 13th 06 10:22 PM


All times are GMT +1. The time now is 08:57 AM.

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"