count if 2 different cells meets 2 different criteria

[Jay]

Count if 2 different cells with different values in 2
different columns meeting 2 different criteria?
A B C
GREEN APPROVED COUNT (if these are true count)

Please don't make me go back to Access.

Thanks in advance

Jay

 

[Don Guillett]

Based on what you asked for, it should have worked.
=sumproduct((rngA="firstcond")*(rngB="secondcond"))
to count
=sumproduct((rngA="firstcond")*(rngB="secondcond")*rngC)
to sum rngC where conditions met in a & c

How about an exact example of your data and the expected answer.

 

[Jay]

A1 constant Q1 based on status, keep count on summary
sheet based on Q Apporved, Completed or Deferred.

summmary sheet
A Q E
1 C5 AR-31058 Approved count
1 C5 AR-31058 Completed count
1 C5 AR-31058 Deferred count

 

[Ken Wright]

Where does it say GREEN in your first column - You don't mean the colour of the cell do you??
Also, why is there a Q after your column A and before Column E?

The formula I gave you will count all instances where there is the text "GREEN" in the first
column, and the text "APPROVED" in the second.