Hi Harsha,

This seems to work...

=SUMPRODUCT((B1<>"Not Yet Presented")+(I1<>"Not Yet
Presented")+(P1<>"Not Yet Presented")+(W1<>"Not Yet Presented"))

Ken Johnson