+ Reply to Thread
Results 1 to 5 of 5

formula for counting

  1. 10-05-2016, 02:00 AM #1
    azbi
    azbi is offline
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Borneo
    MS-Off Ver
    2016
    Posts
    277

    formula for counting

    Dear Expert
    I have two columns source data (type and name of container), I need to count each type that has a container.
    Attached Files Attached Files
    Last edited by azbi; 10-05-2016 at 02:40 AM.
    Reply With QuoteRegister To Reply
  2. 10-05-2016, 02:04 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: formula for counting

    Try this, copied across...
    =COUNTIFS($A$1:$A$22,E$1,$B$1:$B$22,"<>")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 10-05-2016, 02:25 AM #3
    azbi
    azbi is offline
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Borneo
    MS-Off Ver
    2016
    Posts
    277

    Re: formula for counting

    Dear Fort

    the result should be put in column E2, F2, G2 for each type
    Reply With QuoteRegister To Reply
  4. 10-05-2016, 02:40 AM #4
    azbi
    azbi is offline
    Forum Contributor
    Join Date
    07-06-2013
    Location
    Borneo
    MS-Off Ver
    2016
    Posts
    277

    Re: formula for counting

    Dear Fort

    Thanks, its work
    Reply With QuoteRegister To Reply
  5. 10-05-2016, 10:19 AM #5
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: formula for counting

    Happy to help and thanks for the feedback
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need a counting formula
    By Ferloft in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-01-2013, 07:59 AM
  2. Counting Formula
    By mlott1275 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-14-2013, 05:31 PM
  3. Counting Current Streaks in Data/Results (Conditional Counting Formula?)
    By mrvp in forum Excel General
    Replies: 6
    Last Post: 02-04-2012, 06:57 PM
  4. Excel 2007 : Counting formula
    By njnoorani in forum Excel General
    Replies: 2
    Last Post: 12-21-2011, 02:49 PM
  5. Counting Formula
    By MGK in forum Excel General
    Replies: 1
    Last Post: 12-13-2011, 05:48 AM
  6. Looking for a counting formula...
    By bsleeperrr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2008, 10:43 AM
  7. help with a formula for counting
    By wwoody in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2006, 04:00 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1