Hi

I am trying to count multiple cells against multiple criteria in an Excel
spreadsheet:

A B C D
1 Client a Underwriter a Approved Product a
2 Client b Underwriter b Declined Product b
3 Client c Underwriter c Approved Product a
4 Client d Underwriter d Approved Product b
5 Client e Underwriter e Declined Product a
6 Client f Underwriter f Declined Product a
7 Client g Underwriter g Approved Product a
8 Client h Underwriter h Approved Product a
9 Client I Underwriter I Approved Product b

Two results are required:
1) Count €œApproved€� in column €˜C if €˜D = €œProduct a€�€¦€¦ (sum result = 4)
2) If €˜C = €œApproved€� return data contained in cells €˜A & €˜B

Any body? Please.

Regards

EricB