Results 1 to 4 of 4

Finding Averages in a set of cells based on values in part of a set of different cells

Threaded View

  1. #1
    Registered User
    Join Date
    03-23-2017
    Location
    New Hampshire
    MS-Off Ver
    2013
    Posts
    2

    Finding Averages in a set of cells based on values in part of a set of different cells

    NOTE: Sheet is attached

    I have an excel sheet that contains one column ("Email Send Date") with cells that contain both a date and time. For example, "8/18/2016 6:00:00 AM". There are a bunch of other columns with different percentages for a variety of KPIs.

    My question is how can I find averages for these different rates (for example, the unique open rate) based on the time in the "Email Send Date" cell (ex: 6:00:00 AM, 7:00:00 AM, etc.)? Or do I have to separate the date and time?

    Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Average Formula that averages certain cells based on how i filter.
    By phbryan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-20-2015, 04:07 PM
  2. [SOLVED] Finding Averages in Cells with Text and Number
    By mborde3 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-08-2015, 12:52 PM
  3. [SOLVED] returning averages in cells based on autofilter
    By sdtsdt in forum Excel General
    Replies: 5
    Last Post: 02-13-2015, 11:23 AM
  4. HELP Subtracting averages when some cells have no values
    By ztaylor0 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2013, 08:20 PM
  5. [SOLVED] CF based on part of cells vaule
    By robert moore in forum Excel General
    Replies: 15
    Last Post: 10-17-2012, 06:58 AM
  6. Replies: 2
    Last Post: 11-06-2011, 08:16 PM
  7. Sum Cells Based on Current Qtr (Part 2)
    By jkelly228 in forum Excel General
    Replies: 1
    Last Post: 01-27-2011, 03:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1