+ Reply to Thread
Results 1 to 4 of 4

Pulling Data from Dates

  1. #1
    Registered User
    Join Date
    09-18-2011
    Location
    Kansas
    MS-Off Ver
    Excel 2010
    Posts
    40

    Pulling Data from Dates

    Hey, All! I Have a quick question...

    In the little chart on the left, I have the customer name, when their story is due, and when it was completed. On the right, I want to show how many words per hour my journalist is averaging for each week. What I'd like to do in cells J2 through J5 is to have a formula that pulls out the total number of words written for all projects that occurred during that time frame. I can't seem to figure out the formula, though. I was thinking that I needed an array formula starting with ifferror and calling from the row functions, but I can't seem to get it to work out right.

    Can anyone help me out?

    Here's my sample sheet:
    sample data journalists.xlsx

    Thank you so much!!!!

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

    Re: Pulling Data from Dates

    Which date is this based on? The Due date or the Completion date?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Pulling Data from Dates

    Pl see attached file.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-18-2011
    Location
    Kansas
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Pulling Data from Dates

    Double negation to turn the True/False into a number... of course! Thank you so much!

+ 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. Pulling specific dates out of a list of dates
    By bohodgman in forum Excel General
    Replies: 3
    Last Post: 08-07-2013, 01:09 AM
  2. Pulling data from sepeate worksheet based on dates
    By Oklahoma Traveler in forum Excel General
    Replies: 3
    Last Post: 06-12-2012, 12:28 PM
  3. Help pulling data between two dates
    By Caidek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-10-2011, 11:25 PM
  4. Pulling data from a range of dates
    By wtsublette in forum Excel General
    Replies: 1
    Last Post: 03-08-2011, 10:19 AM
  5. pulling data from several worksheets based on dates
    By JESSIER4025 in forum Excel General
    Replies: 1
    Last Post: 02-21-2007, 12:12 PM

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