+ Reply to Thread
Results 1 to 4 of 4

Find data in a column and count values based on the row that it is in.

  1. #1
    Registered User
    Join Date
    10-06-2016
    Location
    Chesterfield, England
    MS-Off Ver
    2010
    Posts
    2

    Find data in a column and count values based on the row that it is in.

    I am having trouble working out a formula for this. Ideally what I want is a formula to do the following;

    Find a name in column A, lets say Joe. And if Joe is in A4 count the amount of times FH shows in row 4

    If this is possible, would it then be possible for the formula to find any specified name (perhaps from a drop down) and then return the amount of times FH appears in the same row as that?

    Thanks in advance.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Find data in a column and count values based on the row that it is in.

    Try

    =SUMPRODUCT(($A$2:$A$100=A1)*($B$2:$ZZ$100="FH"))

    A1="Joe" (your drop down)

  3. #3
    Registered User
    Join Date
    10-06-2016
    Location
    Chesterfield, England
    MS-Off Ver
    2010
    Posts
    2

    Re: Find data in a column and count values based on the row that it is in.

    You are a hero!

    That's perfect thank you!

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Find data in a column and count values based on the row that it is in.

    Thank you the feedback and rep.

    Could you If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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] Find count of Unique or Duplicate Values based on Concatenated values in 2 columns
    By bdicarlo1 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-03-2014, 12:42 AM
  2. [SOLVED] Last Column count based on find.row count
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-23-2014, 11:01 PM
  3. Count Unique values in Column based on values in other columns
    By dmschave in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-17-2014, 11:06 AM
  4. find and then count values in a specific column
    By mubashar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-20-2014, 03:53 AM
  5. Replies: 3
    Last Post: 06-10-2010, 11:54 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1