Counting populated Rows

[Jeffrey Green]

I get a report that has anywhere from 50 to 1000 Rows with two columns.
Column A is the Supplier Code, and Column 2 is Supplier Name.

People type in bad codes in column A and I run an Access query to find the supplier names. So, for example, I will have 50 Codes in Column A and only 45 Supplier Names in Column B.

i want a formula that will count the rows in column A and then divide that into the number of MISSING names in Column B. (I want the error rate)

So in my example I want is 1-45/50 = 90%.

I don't now how to make Excel count the populated rows (a varying number of rows) or how to count the empty cells in column B.


Thanks


Jeff

 

[MAP1168]

you can try this. it worked for me earlier
=COUNTIF(A$1:A10000,"<>")

where column ref of the rows you are trying to count

It only counts the cells that have text or a number input into them

I made a slight adustment. The first row is absolute.

 

[texasalynn]

This will count the populated cells (counta) and the blanks with countblank

Excel Workbook
	H
2	59%
Sheet1

Excel 2003

Cell Formulas
Range	Formula
H2	=COUNTBLANK(E2:E29)/COUNTA(A2:A29)