View Single Post
  #1   Report Post  
Muddock Muddock is offline
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