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.

Trending News

Promoted
Dani
Dani asked in Computers & InternetProgramming & Design · 8 years ago

How do you start counting non-blank cells in Excel?

I have a huge excel sheet and need to be able to count the non blank cells, but not in the entire row...only part of the rows. How do I do that? And where do I put the formula?

1 Answer

Relevance
  • garbo7441
    Lv 7
    8 years ago
    Favorite Answer

    You could structure the formula something like:

    =COUNTA(A1:A3)+ COUNTA(A7:A9)+ COUNTA(B3:B5)

    Put the formula in whatever cell you wish the total to be returned in.

Still have questions? Get your answers by asking now.