+ Reply to Thread
Results 1 to 4 of 4

If statement to look up a specified Range and Average just that specified range

  1. #1
    Registered User
    Join Date
    06-14-2013
    Location
    Orange, Ca
    MS-Off Ver
    Excel 2011
    Posts
    7

    If statement to look up a specified Range and Average just that specified range

    I am wondering if anyone has any thoughts on how to do this? I am trying to show an average of all the data in range B72:B500, for the time period specified in the range A23:A68 and shown in range F72:F500, for the day specified in row 20 and shown in range A72:A500.

    So basically i'm trying to say for this 30 minute time period, on this day, the average "Tick Move Direction" was "X".

    If anyone has any thoughts I where to start I would so so appreciate it.
    Screen Shot 2016-11-04 at 2.02.40 PM.png
    Screen Shot 2016-11-04 at 1.55.52 PM.png

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,117

    Re: If statement to look up a specified Range and Average just that specified range

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,201

    Re: If statement to look up a specified Range and Average just that specified range

    Take a look at using the AVERAGEIFS() function for this. You can include a criteria for the day, and for the time (>=1st time and <= 2nd time)

    If you still have a problem, as Ben suggested, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: If statement to look up a specified Range and Average just that specified range

    Many members are unable to see images in the *.png format due to forum compatibility issues with some browsers.

    If you need to post an image post it in the *.jpg format.

    Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Add IF Statement formula to cells in varying range and paste to used range
    By Webbers in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-26-2015, 01:28 PM
  2. Replies: 1
    Last Post: 11-07-2014, 01:42 PM
  3. to find average with multiple avg range list ( more then 1 avg range)
    By rishikrsaw in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-25-2014, 03:14 PM
  4. [SOLVED] Averageif(range,monthcriteria,[average range])???
    By athyeh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2013, 12:09 PM
  5. Replies: 1
    Last Post: 07-27-2012, 05:37 PM
  6. How Do I Average A Range On A Different Worksheet Then Paste The Average To A Cell
    By Cfallscat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2011, 04:14 AM
  7. Input range only and calculate Average of that range in another cell
    By Kokomo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-27-2007, 09:35 AM

Tags for this Thread

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