How to count null values

[rkpatelqlikview]

  Hi,

Please find the attached excel source file. Data is coming in three stages, I need to count the number of 'PASS' and number of 'FAIL' considering only one stage.

1) Here if the Stage1 only having entry and there is no data in another 2 stages at that time we shold consider Stage1.like that for all.

2) If any stage is having "FAIL" We should consider as "FAIL".

Like this we need to count.  How to count these Pass/Fail from 3 stages following by above condition.

Thanks in advance.

[rkpatelqlikview]

Thank you so much Pradosh,

Its correct one

[rkpatelqlikview]

Thank you for your support Sergu,

[rkpatelqlikview]

Many Thanks Surya. Perfect.

[pradosh_thakur]

please close the thread if you got the answer by marking the appropriate answer correct.