In future do not post with the Caps Lock on - this is regarded as
SHOUTING, is difficult to read, and is considered rude.

Try these:

=COUNTIF(C:C,"OK")

=SUMIF(C:C,"OK",D:D)

Not sure where column E comes into it.

Hope this helps.

Pete

On Jun 17, 9:39*am, PERANISH
wrote:
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. * * * * * * * * * * * * * * *