count missing field

[aditya]

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...

 

[Mike H]

Hi,

Try this in B2

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

Mike

 

[Luke M]

something like this should work:

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

As C, D, F, and K are filled in, counter will decrease to zero.