This is probably pretty easy for 99% of you but I don't use excel much.
What i need to do is place a X in a cell and at the end of the columns give a percentage of how many X's have been placed, if that makes sense.
This is probably pretty easy for 99% of you but I don't use excel much.
What i need to do is place a X in a cell and at the end of the columns give a percentage of how many X's have been placed, if that makes sense.
=COUNTIF(A1:A10,"X")/(COUNTA(A1:A10)+COUNTBLANK(A1:A10))*100
Fear345 (28th April 2015)
OK so in my spreadsheet the cell range i want to perform that calculation is on row 6 columns B to BI.
I put this in =COUNTIF(B6:BI16,"X")/(COUNTA(B6:BI16)+COUNTBLANK(B6:BI16))*100 and after putting a x in every cell it came back with 9.09091
Why didn't it come back with 100? what did i do wrong?
B6:BI16 you not looking at 1 row but 10 rows 6-16 so it is dividing by 10
=COUNTIF(B6:BI6,"X")/(COUNTA(B6:BI6)+COUNTBLANK(B6:BI6))*100
Cheers m8 god knows where the 16 came from lol.
Is there a way of rounding it up to the nearest whole number instead of seeing 21.875 for example?
Format the Cell to a Number with zero decimal places?
Fear345 (28th April 2015)
Superb m8 thanks a lot that worked perfect.
Social Networking Bookmarks