Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Feb 2004
    Location
    Buffalo, New York, Wales
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    dbl lookup + sum (2000)

    Hey Gang;

    I am working on a spreadsheet of sales figures throughout the month. Information is logged stating the date of sale, the source of the contact (newspaper ad, website, etc.) and the amount. I created formulas to count the number of jobs by source for the whole month and also the amount of sales for each source. I need to break that down even further by showing week ending results by source. In the attached file, O4, Q4, S4 and U4 have the week ending date and column L contains the list of sources. I was able to write a formula to sum the number of jobs for each source based on matching the source code and date range. I am hoping some one can help me with a formula that will sum the sales amount if the source code and the date range are met.
    FYI: the date range of 4/3 would include the 1st through and including the 3rd. 4/10 would be the 4th, 5th, 6th, 7th, 8th, 9th and 10th and so on.

  2. #2
    Lounger
    Join Date
    Feb 2004
    Location
    Buffalo, New York, Wales
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: dbl lookup + sum (2000)

    Well I got lucky and found an old post and formula from Hans that put me on the right track and I solved my own problem. I am re-posting my fixed file in case someone could use the formula.

    Thanks to anyone who may have started working on my request.

    yoyophil

Posting Permissions

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