Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    NJ, USA
    Posts
    239
    Thanks
    2
    Thanked 1 Time in 1 Post

    Summarizing data (2000, SR-1)

    I need to (programmatically) summarize an Excel list by unique key. The list has maybe 2000 rows or so, and 73 columns. The first column contains a key; the other 72 columns contain amounts. Does anybody know the quickest way to condense the list so that each key only appears once, and the amounts are summarized? I presume that SUMIF() would be slow, so am looking into sorting the data first, then either using SUM(OFFSET()) formulas, or using Excel's Data Subtotal function.
    Has anybody ever had to do the same thing, or have any thoughts/comments? Thanks.

  2. #2
    Lounger
    Join Date
    Apr 2001
    Location
    Michigan, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Summarizing data (2000, SR-1)

    The quickest way may be to sort and use Excel's Data>Subtotal function, but using the advance filter to get a list of unique values from the first column and then using SUMIF(), may result in a little cleaner look.

    just my uninformed opinion

    Mark

Posting Permissions

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