Counting unique posts in a table with multiple conditions

Hi Im trying to calculate number of rows in a table that fulfil multiple conditions using the COUNTIFS function. My problem is that I only want to count rows holding unique values in one of the colu...