+ Reply to Thread
Results 1 to 2 of 2

Running count of multi-unique values

  1. #1
    Forum Contributor
    Join Date
    08-15-2006
    Location
    USA
    MS-Off Ver
    Office 365, 64 bit
    Posts
    362

    Running count of multi-unique values

    Excel 2007

    Problem:
    Trying to have a running count of a unique dynamic value in Sheet 1 (Summalry tab) B3. Look for that dynamic value in Sheet 2 (Data tab) where it occurs in multi-rows B3:Q25. The totals to sum are in the Q column.

    In other words, find all 11111 in Sheet 2 and sum all totals from column AJ

    Please see attached file...
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Running count of multi-unique values

    rz6657,


    The formula in worksheet Summary, cell C3 (copied down):

    =SUMIF(Data!B:B,$B3,Data!Q:Q)
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

+ 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