Forum Discussion

nikhilnarayanan3553's avatar
nikhilnarayanan3553
Copper Contributor
Dec 23, 2021
Solved

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...
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Dec 23, 2021

nikhilnarayanan3553 That could be something like this:

 

=COUNTIF(B2:E2,"a")/4

 

And format the cell as %

  • nikhilnarayanan3553's avatar
    nikhilnarayanan3553
    Copper Contributor
    Dec 23, 2021
    Its working !!

    Thanks a lot
  • nikhilnarayanan3553's avatar
    nikhilnarayanan3553
    Copper Contributor
    Dec 23, 2021
    Let me check and get back to you.

    Thanks a lot for your help

Resources