Hi,

Try this in B2

=4-COUNTA(C2,D2,F2,K2)

Mike

"aditya" wrote:

i have to fill sheet row wise.
data related to certain column are important to fill (say C,D,F & K column)
i want to do following things

as i start filling a row (say row 2), in B2 it should display 4( because 4
mandatory cells are still to fill i.e. C2,D2,F2 & K2)
Now if i fill C2 , B2 should be 3 (because only mandatory 3 are still to
fill )

similarly if D2 is filled,B2=2 so on & so fourth...