Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help with counting data based on date (2000 sp3)

    Anyone,
    I have a spreadsheet that has several 'names' defined for use in counting data from a defined database on tab 'CR Log'. on the tab defined as document graph, I am in need of a few things. I first need to tally data into three rows based on the received date being less than year 2005. Second for Jan 05 thru dec 05, I need to tally the same three rows, based upon the date. basically, I need to have the column M from the CR Log tab, the be counted and deposited into the proper cell for the month based on the month received date.

    I have attached the spreadsheet. any and all assistance is greatly appreciated.

  2. #2
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help with counting data based on date (2000 sp3)

    Hans,
    It looks like the same file with the same data?

    Brad

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help with counting data based on date (2000 sp3)

    Does the attached version do what you want?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help with counting data based on date (2000 sp3)

    Sorry, like you I forgot the attachment. <img src=/S/blackteeth.gif border=0 alt=blackteeth width=20 height=20>
    Now corrected in my previous reply.

  5. #5
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help with counting data based on date (2000 sp3)

    Hans,
    This absolutly did the trick.

    Thanks !!!!
    Brad

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •