Excel help please

[Fear345]

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.

[akimba]

=COUNTIF(A1:A10,"X")/(COUNTA(A1:A10)+COUNTBLANK(A1:A10))*100

[Fear345]

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?

[akimba]

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

[Fear345]

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?

[akimba]

Format the Cell to a Number with zero decimal places?

[Fear345]

Superb m8 thanks a lot that worked perfect.