count missing field

  • Thread starter Thread starter aditya
  • Start date Start date
A

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