Results 1 to 7 of 7

Formula for Avg from 2 columns (last 10 cells) - A newbie User!!

Threaded View

  1. #1
    Registered User
    Join Date
    07-22-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    7

    Formula for Avg from 2 columns (last 10 cells) - A newbie User!!

    Hello Everyone

    I need some help to develop a formula to find avg of last 10 days and last 5 days
    I m total new to this formula developing thingy.

    Solve this.PNG

    this is the case, I know its simple for u guys..

    I just want the cell to show avg per tap
    like for 10 days we need to add last 10 cells of product column and divide it by sum of last 10 cells in taps used column
    thats it i tried but in vain.. i dont know why..

    Also i want it be blank for present and future dates. (not compulsory)

    thanks in advance
    Last edited by mitrbikram; 07-22-2012 at 05:18 AM.

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