Results 1 to 6 of 6

Alternative to summing nested If's

Threaded View

  1. #1
    Registered User
    Join Date
    06-18-2007
    MS-Off Ver
    2007
    Posts
    77

    Alternative to summing nested If's

    I have a table of approx 20k customers (column A) and their $ sales (column B)for a time period. I need to sum the sales of approx 50 customers. I have the names of the 50 customers to be summed in one column so i can reference them and easily change out a customer if need be. Can anyone suggest an alternative to creating a nested sum that repeats 50 times? I can not change the source data at all, so I have to pull the data into anther area. Thanks.
    Last edited by mashley; 10-09-2009 at 09:39 AM.

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