Hi Everyone,
I have been asked to create a percentage register for work. I now need to be able to convert the outcome of the countif figure to a percentage. This is the formula that I'm using at the moment. Can you please give me some help on how I can do this, please? =SUM(COUNTIF(C4:BZ4,"p")+(COUNTIF(C4:BZ4,"w"))/70*100)
I have been asked to create a percentage register for work. I now need to be able to convert the outcome of the countif figure to a percentage. This is the formula that I'm using at the moment. Can you please give me some help on how I can do this, please? =SUM(COUNTIF(C4:BZ4,"p")+(COUNTIF(C4:BZ4,"w"))/70*100)