Thread: AVERAGE formula covering a date range
View Single Post
  #3   Report Post  
bala_vb bala_vb is offline
Senior Member
  
Location: Hyderabad
Posts: 237
Thumbs up
Quote:
Originally Posted by Muddock View Post
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
try this formulae
=SUM(O3:O65536)/COUNTA(O3:O65536)
__________________
Thanks
Bala
Reply With QuoteReply With Quote