Average if contains a specific word

Average if contains a specific word

Hi!

I'm trying to type a formula which could tell me the percentaje of the cells that are in color green, those cells are painted in green when I type the word "Listo", so I found that formula (showed in the image) in the community questions, but when I type that formula it drops me a 0. Could somebody tell me how can I make it work in my sheet?

Thank you!


Best Answers

Answers

  • Hi Paul!

    Thank you, it worked! :D

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help! 👍️

    

  • Hi Paul!,

    Me again, do you know how can I complement this formula if I want to include " No aplica" so that to don't count this sentence and to only sum the ones which are in color green. So even if I have all those CHILDREN painted in green but I have that " No aplica" sum anyways a 100%.


    Thank you!


  • Thank you Paul, it worked perfectly!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Great! Happy to help! 👍️

Sign In or Register to comment.