+ Reply to Thread
Results 1 to 4 of 4

Give any not blanks, a value of 1

  1. #1
    Forum Contributor
    Join Date
    04-09-2010
    Location
    Fort Myers, FL
    MS-Off Ver
    Excel for MAC
    Posts
    127

    Give any not blanks, a value of 1

    I have about 50 rows, some are blank, some have numbers in it. I want to add up on the bottom, how many cells have values. So basically no matter what the value is, it will be converted to a "1" so if 15 cells have values, it would be 15.

    Thanks!

    Nick

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,053

    Re: Give any not blanks, a value of 1

    Try this:

    =COUNTA(A1:A50)

    Change the range to suit.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Forum Contributor
    Join Date
    04-09-2010
    Location
    Fort Myers, FL
    MS-Off Ver
    Excel for MAC
    Posts
    127

    Re: Give any not blanks, a value of 1

    Boom! The End! Thank you!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,053

    Re: Give any not blanks, a value of 1

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. BLANKS (Not Really Blanks) AND Rearrange ignoring blanks
    By shivspatil in forum Excel General
    Replies: 4
    Last Post: 02-02-2018, 08:28 AM
  2. [SOLVED] Ignore blank cell to give give non zero result
    By rehan0129 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-24-2018, 12:04 PM
  3. [SOLVED] why give me error #VALUE ... i need to give me the numbers from small to big
    By mena in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-22-2015, 10:11 AM
  4. Replies: 2
    Last Post: 07-03-2015, 04:08 AM
  5. [SOLVED] Compare two ranges of data and give unique values in two different columns ignoring blanks
    By rampulaparthi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2013, 04:17 PM
  6. [SOLVED] Give RELEVANT responses to questions. DO NOT give usless list
    By pmartin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-06-2006, 02:00 PM
  7. Replies: 0
    Last Post: 02-22-2005, 12:06 AM

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