CountIF Field equals a text variable

[bsnoles]

I have a table with multiple fields and I need to count the number of records with the text variable of 'Update Record' based upon another field but I only want to count the 'Update Record' once based upon the second field.  For example:

1st field name is Record Reporting Category is equal to 'Update Record' then count but only count it one time based upon the 2nd field name of Record UID.

Any help would be appreciated.

[MendyS]

@bsnoles 

I am not sure that  I  got you,

you want to count even if the "CCarR Record Reporting Category" is empty? or if "CCarR Record UID" is empty?

[bsnoles]

Reporting category is null