Results 1 to 10 of 10

[solved]Count if cell from one column is equal to cell in other column

Threaded View

Benderis [solved]Count if cell from... 09-17-2016, 06:59 AM
José Augusto Re: Count if cell from one... 09-17-2016, 07:07 AM
Benderis Re: Count if cell from one... 09-17-2016, 07:21 AM
Tony Valko Re: Count if cell from one... 09-17-2016, 08:12 AM
Benderis Re: Count if cell from one... 09-17-2016, 09:25 AM
Tony Valko Re: Count if cell from one... 09-17-2016, 10:22 AM
Tony Valko Re: Count if cell from one... 09-17-2016, 10:34 AM
José Augusto Re: Count if cell from one... 09-17-2016, 07:37 AM
Benderis Re: [solved]Count if cell... 09-17-2016, 10:59 AM
Tony Valko Re: [solved]Count if cell... 09-17-2016, 11:17 AM
  1. #1
    Registered User
    Join Date
    09-17-2016
    Location
    Lithuania
    MS-Off Ver
    2013
    Posts
    11

    [solved]Count if cell from one column is equal to cell in other column

    Hello. I need a little help. It's been bothering me for hours now and I'm out of patience. I need to count how many times Number in Column A is equal to number in Column B. So A1=B1, A2=B2, A3=B3 and so on... I need answer in one cell (I could do it if I would use one more column for example in C1 I would write IF(A1=B1;1;0), C2 IF(A2=B2;1;0) and so on..., but I need more space efficient way now), I tried using COUNTIF(A:A;"="&B:B), COUNTIF(A:A;"=B:B), COUNTIF(A:A;B:B) and so on.. (I use A:A, B:B..., because it's quicker), but it doesn't give me the right number (actually, I get different numbers if I copy the same formula one row lower)..
    Last edited by Benderis; 09-17-2016 at 07:52 AM.

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: 12-15-2014, 06:15 PM
  2. [SOLVED] Set cell equal to variable cell (from set column) based on cells in adjacent column
    By alter54 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2014, 01:04 PM
  3. [SOLVED] count number of cells in Column C that have a lesser or equal value to the adjacent cell
    By Geoff Jones in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-18-2013, 11:01 AM
  4. Replies: 4
    Last Post: 05-08-2013, 08:33 AM
  5. [SOLVED] Cond. formatting a column/Range, highlight cell in column/range if equal to specific text
    By DFrank231 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2013, 03:35 PM
  6. Replies: 11
    Last Post: 01-18-2013, 04:05 PM
  7. Replies: 12
    Last Post: 09-06-2012, 07:24 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