Need formula to count blank cells

G

George

Need help to create a formula to show percentage of how many time
each person attended training each year - requirement is once a month.

Down column "A" are their names, columns "B1" thru "M1" are the 12 months.
If they show for their monthly class I place an X in the cell if not I leave
it blank. In Coulmn "N" for each person I am looking to enter a formula that
will basically count the blank cells - subtract that from 12 and then divide
that value by 12 which should give me the percentage of times that they
showed up for class that year.

If that makes sense !

Thanks - George
 
J

Jacob Skaria

Try the below and format the formula cell to %
=COUNTIF(B1:M1,"X")/12

OR

=COUNTA(B1:M1)/12

If this post helps click Yes
 
J

Jacob Skaria

If I understand you correctly;

Cells(1, ActiveCell.Column)

will give you the value of cell 1 or Row1 of the active cell/column

reportWS.Range("D" & reportCurrentRow) = Cells(1, ActiveCell.Column)


If this post helps click Yes
 
G

George

They all work - Always more then one way to skin a cat !

Thanks - Greatly Appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top