counting device
 

Hello everyone.

Can anyone help me with devise a counting tool that looks through a column
on my excel spread sheet and each time the number in the cell is greater
than 1, the count increases. Until it reaches the end of the column.

The number of rows that will be populated with number will be a variable,
and I need the counter to adjust to this. What I mean by this is, that a
user will select how many numbers to record in, say, column A. If the user
populates 20 rows, then I need my counter to check through each of those 20
cells and tell me how many of these are than 1. If 25 cells are populated
then, need it to check through all 25 cells, and so forth.

I also need a calculation to be feed out, which tells the user as a
percentage how many of cells are greater than 1 in relation to the total
number of cells.

Any help would be very appreciated. Thank you all in advance.

Nazmul Hasan