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
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