lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
hi
I have table like the one below. I calculate grade using if() function, a for >80, b for >70 etc. The I used countif() to find out how many a,b,c, and f, I have.
a = 1
b = 10
c = 3
f = 4
My question, I want excel to give me the percentage % of a, b, c, and f. so I want to have something like this
a = 7%
b = 40%
c= 33%
f=20%
Is that possible? Thank you so much
[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]name[/TD]
[TD]mark[/TD]
[TD]grade[/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD]100[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]mary[/TD]
[TD]70[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]alex[/TD]
[TD]40[/TD]
[TD]f[/TD]
[/TR]
</tbody>[/TABLE]
I have table like the one below. I calculate grade using if() function, a for >80, b for >70 etc. The I used countif() to find out how many a,b,c, and f, I have.
a = 1
b = 10
c = 3
f = 4
My question, I want excel to give me the percentage % of a, b, c, and f. so I want to have something like this
a = 7%
b = 40%
c= 33%
f=20%
Is that possible? Thank you so much
[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]name[/TD]
[TD]mark[/TD]
[TD]grade[/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD]100[/TD]
[TD]a[/TD]
[/TR]
[TR]
[TD]mary[/TD]
[TD]70[/TD]
[TD]b[/TD]
[/TR]
[TR]
[TD]alex[/TD]
[TD]40[/TD]
[TD]f[/TD]
[/TR]
</tbody>[/TABLE]