COL-A COL-B COL-C COL-D COL-E
A3212 AC-A3654-023-02 2-2 OK 5
A3212 AC-A3654-023-02 2-1 OK 5
A3212 AC-A3654-023-02 4M NO 10
A6250 AC-A3655-024-03 1-M1 OK 4
A6250 AC-A3654-023-03 2 OK 8
A5630 AC-A3654-023-02 2-M2 OK 2

I WANT RESULT IF COL-D = OK, COUNT, COL-C & SUM COL-E( FOR THIS RESULT WILL
BE, 5 & SUM-24)
ANOTHER RESULT, IF COL-D=OK, COUNT, COL-B , VOIDING OF DUPLICATES(FOR THIS
RESULT WILL BE, 3)

Request you to help on this & to save my time.