CODEWITHSUNDEEP
excelexcel-formulacountif
Conor12x
Conor12x

Reputation: 39

CountIF cell value matches adjacent cell

I have a table used to track document versions and whether or not a user has read the most up to date version. I want to track the number of up to date documents read per user and I'm really struggling with CountIF.

enter image description here

How do I count the number of times UserA matches Doc version?

What I have tried is =COUNTIF(A1:A12, "="&B1:B12) which gives multiple rows of results I don't really understand. I have also tried =COUNTIF(A1:A12, "="&B1) but of course that just matched to B1.

Thanks

Upvotes: 0

Views: 3791

Answers (4)

Jude Michael David
Jude Michael David

Reputation: 1

=COUNTIF(A1, "="& B1)

Then copy/paste it to all cells.

Upvotes: 0

Conor12x
Conor12x

Reputation: 39

The comment by @JvdV answered the question:

=SUMPRODUCT(--(A2:A13=B2:B13))

Upvotes: 1

Can.U
Can.U

Reputation: 481

enter image description here

=SUMPRODUCT((A2:A23-B2:B23=0)*(A2:A23<>""))

Upvotes: 0

Rajput
Rajput

Reputation: 605

You can at least attach a sample file.

=SUMPRODUCT(--(A1:A13<>B1:B13))

Upvotes: 0

Related Questions