How to get unique values from Countifs funcation

[petes]

Name (A Column)	Marks (B Column)
John	3
John	3
John	2

The above is my data and have used the following formula. The formula should give the result as "1" instead of "2". Because, John is having same marks in 2 rows. Let me know how to tweak this formula

John (E column)

=COUNTIFS(A1:A3,E1,B1:B3,">2")

 

[Peter_SSs]

Need to check few more things and then mark it as resolved.

.. also still need to update your account details to include your Excel version.

 

[Peter_SSs]

@petes
Please do not mark a post as the solution unless it does actually contain the solution to your original post. Clearly post #11 does not contain a solution so I have removed the 'Mark as solution' from that post.
.. and you still have not acted on that request.