+ Reply to Thread
Results 1 to 4 of 4

Count as separate entries

  1. #1
    Registered User
    Join Date
    04-02-2016
    Location
    Sydney
    MS-Off Ver
    2013
    Posts
    12

    Count as separate entries

    Hello.

    I really hope this is going to make sense ...

    I need a formula to calculate the B and X lines, but only count them if there is a X in the same row.

    I have a formula that will count the B but instead of having 2 x b/x and 1 x b it is adding it all up so my counts are 2 x b/x & 3 x b, this is inaccurate for my reporting.

    Thanks for your help.
    Attached Files Attached Files

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,816

    Re: Count as separate entries

    So basically you want to count the number of rows only if Column B has a B and Column F has an X on the same line.

    So in the attached file, such is the case 3 times? Am I right?

    If that is what you want, try this

    =SUMPRODUCT(($B$2:$B$700="B")*($F$2:$F$700="X"))
    Cheers!
    Deep Dave

  3. #3
    Forum Contributor
    Join Date
    02-07-2013
    Location
    Karachi, Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    290

    Re: Count as separate entries

    Hi,

    Or similar to Dave's, but with COUNTIFS:

    =COUNTIFS(B2:B700,"B",F2:F700,"X")

    Blessing
    Khalid

  4. #4
    Registered User
    Join Date
    04-02-2016
    Location
    Sydney
    MS-Off Ver
    2013
    Posts
    12

    Re: Count as separate entries

    Thank you for the input. I must be doing something wrong? I cant get the formula's to provide an accurate count.

+ 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. Replies: 3
    Last Post: 04-07-2016, 08:45 AM
  2. [SOLVED] Matching entries on separate tabs ...
    By reglook0736 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-09-2015, 12:37 PM
  3. Replies: 0
    Last Post: 08-11-2014, 12:52 PM
  4. [SOLVED] How can I count line entries based on meeting criteria for 2 separate columns?
    By neilrk7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:57 PM
  5. separate the data from the 25 entries on the master to separate worksheets
    By nemo12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2012, 09:27 AM
  6. [SOLVED] Posting entries from one userform to separate worksheets.
    By melcoats in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2012, 02:10 PM
  7. Count names from separate worksheet, and from separate rows
    By juicestain09 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-05-2012, 09:36 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