Forum Discussion
Percentage calculation
I want to know the formula for calculating the tick mark percentage.
I have a listing file for 10 products and have 20 customers.
Customers item 1 item 2 item 3 Item 4 percentage
Customer 1 a a r r 50%
Customer 2 r r r r 0%
In the above showed is my table "a" is tick mark and "r" is into mark. I want to get the tick mark percentage calculating formula.
Please help me out on this.
Thank you
nikhilnarayanan3553 That could be something like this:
=COUNTIF(B2:E2,"a")/4
And format the cell as %
5 Replies
In row 2:
=COUNTIF(B2:K2,"a")/COUNTA(B2:K2)
Adjust the range if needed, and format the cell with the formula as a percentage.
Then fill down.
- nikhilnarayanan3553Copper ContributorThanks a lot for your valuable response
- Riny_van_EekelenPlatinum Contributor
nikhilnarayanan3553 That could be something like this:
=COUNTIF(B2:E2,"a")/4
And format the cell as %
- nikhilnarayanan3553Copper ContributorIts working !!
Thanks a lot - nikhilnarayanan3553Copper ContributorLet me check and get back to you.
Thanks a lot for your help