Division problem with % Complete

Greetings,

I have the following formula but it's not giving me the results I want.
=(COUNTIF(K11:K58,"Complete")+COUNTIF(K11:K58,"N/A"))/COUNTA(D11:D58)

What I want to do is display a % complete of the columns that have a related value in D11:D58. I want to ignore N/A in the % complete and I want to ignore all cells below my range that do not have a corresponding value in D11:D58. I can't specify a fixed range because the D column is dynamic.

Hopefully this makes some sense. Any ideas?
Thanks!

DW

I'm a little confused. If you have blanks in the other rows in D, a COUNTA referencing the entire column would work (updating the other sumifs likewise, of course). Also, I'm not certain what result specifically you're looking for that you're not getting. Could you please post a sample workbook with dummy data showing an example of the results you're looking for and why?

darkyam,

I figured it out. Sorry I wasn't very clear. My solution was to plug in this formula:
=(COUNTIF(K11:K58,"Complete"))/COUNTA($D$11:$D$58)-COUNTIF($D$11:$D$58,"N/A")

Thanks for the reply!
DW