Hi, this is my first post so bear with me please!

I am working on building an Excel Sheet that has a list of projects I have bid on. This list is being added to all the time. The most recent projects get added to the bottom of the list. I want to keep a running percentage of the number of projects awarded divided by the number of projects bid on:

# projects awarded / # projects bid

The tricky part is combing functions in the cell where the percentage is displayed (at the top of the page) because the number of projects will change as I add to the list. So I cant just divide by a constant number. I am looking for a function that will find the number of cells in a Column that have data in them, and divide by a different number.

What I was thinking was having a column (titled "Awarded ??") that will be populated with "yes" if the project was awarded, and left blank if the project was not given to me. Then I will use a COUNT function to find the number of "yes". Then I just need to find the total number of projects ( at that point in time) and divide the two.

I have tried using two count functions (counting names of projects, and counting job numbers if awarded) and dividing them but was given an error message of "#DIV/0!"

Any suggestions would be a huge help, Thanks!