Percentage total with blank cells

[manofoak]

Thank goodness I found this! Please help

So here is my question.

I have a list of 25 employees (cells A1:A25) with an additional 5 cells reserved for future employees (A26:A30)

I have a group of 30 cells (B1:B30) that, when certain employee training criteria are met, will have the letter "x" typed into them.

Below these 30 cells is a "total" cell. What I would like for this cell to show is the total percentage of training completion of the employees listed. I would normally use =COUNTA(B1:B30)/the total number of cells, but I do not want the formula in the "total" cell to calculate the blank cells that may or may not exist in cells B1:B30.

Basically I want to be able to put an x in those cells and get a percentage of those cells containing an x without counting blank cells.

Example:

John x
Sally
Jeff x
Mike x
"blank"

Total
%

Can you help me?

Thanks

Brian Aragon

 

[DonkeyOte]

Welcome to the Board.

Perhaps:

=COUNTIF($B$1:$B$30,"x")/COUNTIF($A$1:$A$30,"*?")

 

[manofoak]

OMG!. That worked like some creepy voodoo excel magic! Thanks! You are the best!

-Brian

PS
Yes. Ur A$$ looks HUGE

Alternately, if the cells containing "x" contained a percentage, how could I then get an average of the percentages ignoring blank cells?

Thank you again.

 

[DonkeyOte]

=AVERAGE($B$1:$B$30)

assuming the blanks are just that (ie blank as opposed to null)