count missing field
 

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

count missing field
 

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

count missing field
 

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


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