Results 1 to 6 of 6

Counting and Summation Question

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2013
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    2

    Counting and Summation Question

    Here is the data I am dealing with. Two columns ID and Type:

    ID Type
    1 Report
    1 Report
    1 Workflow
    2 Form
    3 Report
    3 Form

    I need to summarize this as:

    Report 2
    Workflow 1
    Form 2

    I need to only count the same Type with the same ID once. Currently I am using COUNTIF but that counts report with id 1 twice. Also wanted to add that ID can be alpha neumeric

    Thanks,
    Last edited by mangoMan1; 09-05-2013 at 01:21 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need help counting and summation values associated with text
    By DonAdrian.needs.help in forum Excel General
    Replies: 3
    Last Post: 12-19-2012, 12:34 AM
  2. [SOLVED] Summation Formula Question (Code Inside)
    By cjwenngatz@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2006, 02:10 PM
  3. Counting question
    By Brad in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-08-2006, 01:00 PM
  4. Counting Question
    By Metalteck in forum Excel General
    Replies: 1
    Last Post: 06-21-2005, 04:05 PM
  5. Counting question
    By Carl in forum Excel General
    Replies: 11
    Last Post: 03-11-2005, 06:06 PM

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