count missing field

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top