+ Reply to Thread
Results 1 to 8 of 8

Function possible for Using specific number to count other specific numbers total ?

  1. #1
    Forum Contributor
    Join Date
    06-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2019 Version1808
    Posts
    302

    Function possible for Using specific number to count other specific numbers total ?

    Hi Expert,
    Attempting to count total specific numbers in a large data when specific number appears....
    Using filter takes lot of time but wondering some function may be available
    ( Excel 2007)

    Example


    A B C
    2 6 4
    4 8 6
    6 2 8
    6 8 2
    2 6 6
    2 4 8
    6 8 4
    8 2 4
    8 6 2
    Goal seeking

    Task: use number from column A (say 6) and count how many time 8 appears when 6 appeared in column A

    Result( Counted Manually)
    when 6 appeared (column A) , 8 appeared three times (from column B & C)

    Thanks
    Karnik

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Function possible for Using specific number to count other specific numbers total ?

    Yes... but is there any reason why 8 should be counted, when 6 is selected, as opposed to any other number?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Function possible for Using specific number to count other specific numbers total ?

    Ahhh.. Do you mean count the 8 in row B&C if 6 appears in column A of the SAME row???
    Attached Files Attached Files
    Last edited by Glenn Kennedy; 05-02-2015 at 03:09 AM.

  4. #4
    Forum Contributor
    Join Date
    06-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2019 Version1808
    Posts
    302

    Re: Function possible for Using specific number to count other specific numbers total ?

    Hi Glenn
    Thanks for looking in to it, it is for one to one relationship in the data in a row
    Similarly, I may have to use other number to find relationship. Col A will always be main one to select
    Currently I use data filter and that is bit time consuming ...more of manual looking for faster option
    Regards
    Karnik

  5. #5
    Forum Contributor
    Join Date
    06-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2019 Version1808
    Posts
    302

    Re: Function possible for Using specific number to count other specific numbers total ?

    Hi Glenn, yes!!

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Function possible for Using specific number to count other specific numbers total ?

    Sorry, I didn't see your last two posts. I have added a possible solution to post # 3.

  7. #7
    Forum Contributor
    Join Date
    06-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2019 Version1808
    Posts
    302

    Re: Function possible for Using specific number to count other specific numbers total ?

    Hi Glenn,
    Perfect!!
    Thank you so much... in fact this is ultimate folution for me.....
    Cheeeers
    Karnik

  8. #8
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: Function possible for Using specific number to count other specific numbers total ?

    Thanks for the Reputation that you have added. It's much appreciated. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Collecting a total value of a specific from specific hours and number of days
    By jexzard in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-15-2013, 09:20 AM
  2. count total of a specific number a row
    By eznugget in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2013, 07:03 PM
  3. how to count the total number of specific word in a column
    By darkhorse4321 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-27-2010, 09:26 AM
  4. how to count the total number of specific word in a column
    By darkhorse4321 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2010, 09:16 AM
  5. Count and Sum Total occurrances of two specific numbers
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-29-2005, 04: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