Results 1 to 3 of 3

Total Units for each Customer

Threaded View

  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.

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