Reputation: 39
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.
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
Reputation: 39
The comment by @JvdV answered the question:
=SUMPRODUCT(--(A2:A13=B2:B13))
Upvotes: 1
Reputation: 605
You can at least attach a sample file.
=SUMPRODUCT(--(A1:A13<>B1:B13))
Upvotes: 0