Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Dia
Lv 5
Dia asked in Computers & InternetSoftware · 7 years ago

Need some help with a microsoft excel formula?

Hi everyone

I have very basic knowledge of excel so I am a bit lost here. I have an excel file where I maintain my data. I need a formulae to count the number of times the word “nil” appears on sheet 1. Also I need this formula on sheet 2. I'm using excel 2010 at the moment. I will be glad if someone could help. Thanks.

1 Answer

Relevance
  • 7 years ago
    Favorite Answer

    on sheet 2 type =countif(

    then select where you want to count then , then "nil".

    done.

Still have questions? Get your answers by asking now.