Results 1 to 7 of 7

Average by number of months

Threaded View

  1. 08-16-2013, 04:07 PM #1
    morbdetro
    morbdetro is offline
    Forum Contributor
    Join Date
    10-05-2012
    Location
    Washington
    MS-Off Ver
    Excel 2013
    Posts
    110

    Average by number of months

    I am a little stuck on this one and hopefully somebody will be able to help me out. I have a large data file that contains the usage for all my parts. I am looking to average their usage so I can plan my purchasing accordingly. What I am hoping for is a formula that will count the number of months between the first issue of a part and today then divide the total usage by that number.

    I have attached a sample of of my data.

    Thanks in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Average a number into months left in year
    By jgryctz in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-14-2013, 02:50 PM
  2. Average - Change the number of months
    By sandraj2013 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-16-2013, 04:53 PM
  3. Number of months (elapsed months) between two dates
    By Timbite in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-17-2012, 11:37 AM
  4. [SOLVED] Average - 3 months / 6 months trend line ( array formula? )
    By ccernat in forum Excel General
    Replies: 3
    Last Post: 04-04-2012, 06:24 AM
  5. Average Months into Years/Months
    By mv835 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2011, 02:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1