Counting unique items only when a condition has been met

Hello,

I hope that I can explain this clearly. Please bare with me.

I've attached a spreadsheet for a better visual. Basically what I would like to do is count the unique document only when both have been approved.

Column A = Number (nothing special with this column)
Column B = Area (only two shown in the example)
Column C = Document (only one shown in the example)
Column D = Document Count (this has a formula to count unique "documents" for each "area")
Column E = This is where I will place the word "Approved"

Currently, in my master spreadsheet, when I place "Approved" in cell E2, it will count the number contained in D2. I wish to have it count D2 only when both E2 and E4 are "Approved".

The current count formula that I use is: =COUNTIFS($C$2:$C$5,"Airplane",$D$2:$D$5,"1",$E$2:$E$5,"Approved")

The problem that I am having is that when a somebody approves line 4, is does not count, nor do I want that. I would like it to count when both line 2 and line 4 are "Approved"

Hopefully this made some sense.

Thank you!!

There are several ways to get the desired result, one way, based on the sample file

In C2,

Formula:

Please Login or Register  to view this content.

Then count with

Formula:

Please Login or Register  to view this content.