+ Reply to Thread
Results 1 to 3 of 3

Need HELP with conditional usage formula

  1. #1
    Registered User
    Join Date
    08-01-2007
    Posts
    5

    Need HELP with conditional usage formula

    Need help creating a formula that computes the average usage for given data. I do not want to average the data; I want to average the changes in the data. My problem is that my data lines are not equal for all products on spreadsheet (one product may have 3 lines of data, and another product may have 6 lines of data). Example of one product:
    data line 1 25,000
    data line 2 32,000
    data line 3 38,000
    total change (usage) is 13,000 and my average usage is 4,333 (13,000/3)

    Is there a conditional formula that will calculate my average usage for each change in product??

    Thanks for any help.

  2. #2
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,527
    Hi there,

    Assuming the amounts are in Column B (change the Column reference if necessary), does the following formula help?

    =(B3-B1)/COUNT(B1:B3)

    Kind regards,

    Robert

  3. #3
    Registered User
    Join Date
    06-23-2007
    Posts
    3
    Assume that you have 10 dataline & all the data in Column B
    This may helpful to you!
    =(max(b1:b10)-min(b1:b10))/count(b1:b10)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1