LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default Average of time each month

I am trying to get an average of time spent each month on an activity. The
spreadsheet has 12 months and only 3 of the months are populated.I think it
is still counting months 4-12 in my average. As each months time is entered I
want it to recalculate the average.

Example : April 120 min, May - 135 min, June 105 min
(Time is in minutes)

=IF(SUM($M$88,$P$88,$S$88,$V$88,$Y$88,$AB$88,$AE$8 8,$AH$88,$AK$88,$AN$88,$AQ$88,$AT$88)<=0,"",AVERAG E($M$88,$P$88,$S$88,$V$88,$Y$88,$AB$88,$AE$88,$AH$ 88,$AK$88,$AN$88,$AQ$88:$AT$88))

The above gives me the average of 30 min rather than 120 min. Please advise

 
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
Help with Weighted Average Per Month Terry Excel Worksheet Functions 0 October 3rd 07 07:29 PM
Average Less a Month Jani Excel Discussion (Misc queries) 4 September 26th 07 09:04 PM
12 Month Average Dewayne Excel Worksheet Functions 10 November 6th 06 09:18 PM
=AVERAGE(IF(INT(MONTH(C:C)+2/3)=4 kathi Excel Worksheet Functions 5 February 28th 06 10:55 AM
Average starting with first month Jim Excel Discussion (Misc queries) 7 October 29th 05 12:48 PM


All times are GMT +1. The time now is 11:04 AM.

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

About Us

"It's about Microsoft Excel"