Getting tables to show % of data entry

[TTej]

is it possible to somehow get and idea of how showing how much data has been entered and how much is missing and linking this to another sheet.

ive got my master which each department add to.

what i want is to make another table tracking the the physical amount of data given.

eg: asking ten people location, 6 people answer so in the other table i can say branch X has a return rate of 60% for location entering.


obviously im not working with just 10 entries, last count was over 4000 and across 28 fields.

thanks.

[shg]

It depends on how your data is arranged, but perhaps something like =COUNTA(Range) / ROWS(Range)

[TTej]

It depends on how your data is arranged, but perhaps something like =COUNTA(Range) / ROWS(Range)

i was thinking is there a way of working it out like this.


count number of blank cells in a row and compare that to the total of rows (inc. blank and filled cells).

im i on the right tracks or completely off??

[shg]

You could do it that way also:

=COUNTA(Range) / ( COUNTA(Range) + COUNTBLANK(Range) )