+ Reply to Thread
Results 1 to 3 of 3

COUNTIF Help?!?

  1. #1
    Registered User
    Join Date
    01-29-2007
    Posts
    3

    COUNTIF Help?!?

    Could someone please help with this possibly simple formula...

    I want to be able to count cells that have data in them (weather that be text or numbers). So in a range of cells I if there are 10 cells with info and 5 left blank I want it to return the answer of 10. Of course my range is much larger though.

    I was trying COUNTIF formulas, but got nowhere.

    Thanks.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,697
    Try COUNTA, this counts both text and numbers ( it also counts so-called "formula blanks" so it's not good if your "blanks" are generated by formulas). Just

    =COUNTA(your_range)

  3. #3
    Registered User
    Join Date
    01-29-2007
    Posts
    3
    Champion! Thankyou, I knew it was something simple.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1