Help with Percentages

[Timto]

This will sound silly but here goes.
I am working on a spreadsheet to keep attendance at meetings. I have used "X" to mark someone present. I have calculated all of the "X's" to once column then I want to get a percentage of meetings they attend. Here is what I have:

=COUNTIF(A3:V3,"X") - This gives me the number of meetings attended there are a total of 21 scheduled.
=(X3/21)*100 - This should give me the percentage of meetings attended.

Problem is I get 476%, I know it will be something simple, just wanted to ensure the formulas were right and it should be something simple confusing me.

Any help would be GREATLY appreciated.

Timto

[Chris 53]

Try '/' instead of '*'

[AliGW]

Not getting that result here. If I put X into 16 cells, I get 76.19047619.

[RheaLocci]

First check - what's the value in X3? It is less than 21, right?
I think the *100 is right to look at %age.
The problem must be that X3 is more than 21. Are you accidentally doing A2:V3? This would add two people.

[Chris 53]

Try x3/21

format x3 for a percentage.

[Timto]

First check - what's the value in X3? It is less than 21, right?
I think the *100 is right to look at %age.
The problem must be that X3 is more than 21. Are you accidentally doing A2:V3? This would add two people.

Total Percentage

1 476%

This is what shows up and this is what I have for the formulas.

Total
=COUNTIF(A3:V3,"X")

Percentage
=(X3/21)*100

There are 21 day of meetings I have in this scenario marked this attendee as being at the first meeting , the rest are blank.

Not sure if this is a formula issue or a numbering issue? Everything seems to be fine with the formulas.

[RheaLocci]

Looks like you have **BOTH** the (*100) in the formula AND the target cell formatted as a "percent" which automatically multiplies by 100 to make a percent. You only need one of those. Your answer is simply 100x too big. 1/21= 0.0476 as a percent that should be 4.76%. By formatting your cell as % and also multiplying by 100 you have double dipped on percentagizing your number. Either take out the *100 _or_ format the cell as a simple number.

[Timto]

Works like a dream, thanks. I feel stupid, but happy.

[vlady]

FORUM MODERATOR'S REQUEST:

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as "SOLVED".
For the meantime I'll do it for you.

How?
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Note:
You can also thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given.
By doing so you can add to the reputation(s) of those who helped and shared their time in helping you.