COUNTIF - counting 2 sets of data?

I have a bit of a confusing issue, I know the solution must be rather simple but I cannot get my head around it.

I am trying to count windows for a house, but the issue arises when windows and sliding doors can come the same size.

I have been using COUNTIF, which works great for windows only, but when the sliding door with the same window size exists - the formula fails.

I have attached an example and a more detailed explanation there.

Can't you use COUNTIFS ?

For Column F use
and pull formula down

=COUNTIFS(C$3:C$7,F3,D$3:D$7,"<>Yes")

For S/DOOR

=COUNTIFS(C$3:C$7,I5,D$3:$D7,"Yes")

For windows use

Please Login or Register  to view this content.

For S/Door use

Please Login or Register  to view this content.

You're welcome