Dear Mr.Pete,
Thank u fro ur fromula & nice working. Same time, i want sformula for 2nd
Option

"Pete_UK" wrote:

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.