+ Reply to Thread
Results 1 to 3 of 3

Total Units for each Customer

  1. #1
    Registered User
    Join Date
    02-03-2009
    Location
    Mount Pleasant, Texas
    MS-Off Ver
    Excel 2003
    Posts
    2

    Total Units for each Customer

    Hey guys!

    I have been tasked with tracking the expected income for our Advertising Department. (I work for a newspaper.) The rate I charge an ad depends upon the total number of advertising units a customer purchases during an entire billing period.

    Essentially: I need to have a total of column G for when column B matches the current row. I need this in column K. The value of K should be the same when the value of B is the same.

    My programing flow chart I sketched out checked to see if any row in column B that is above the current row matched the current row's data. If it did then it would use that row's value for the total number of units. If it did not it would add up the units from G when B matched the current column.

    I attached a document that might help.
    FYI: When I say units I mean Column Inches.

    Sorry if I'm a bit scattered.
    My brain is about to explode.
    Thanks for any help!
    I really appreciate it.

    -Boozik
    Attached Files Attached Files
    Last edited by Boozik; 02-03-2009 at 03:09 PM.

  2. #2
    Forum Contributor
    Join Date
    08-21-2006
    Location
    Ossett, West Yorkshire
    MS-Off Ver
    2003
    Posts
    150

    Re: Total Units for each Customer

    Hi,
    If I have understood you correctly then the formula to be entered into K3 and coppied down is:
    =SUMIF($B$3:$B$7,B3,$G$3:$G$7)
    this gives the answer that you require.
    Regards Howard

  3. #3
    Registered User
    Join Date
    02-03-2009
    Location
    Mount Pleasant, Texas
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Total Units for each Customer

    You do indeed understand me!
    That works perfectly.
    I just changed the 7's to 1000 and I think this is exactly what I needed.

    Thank you for your help, Howard.

    -Boozik

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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