Page 1 of 2 12 LastLast
Results 1 to 10 of 12
Like Tree5Likes

How to count formulas countaining any values.

This is a discussion on How to count formulas countaining any values. within the Excel Questions forums, part of the Question Forums category; I need a row count formula that will only count the cells with a value inside of them. Unable to ...

  1. #1
    New Member
    Join Date
    Nov 2015
    Posts
    12

    Default How to count formulas countaining any values.

    I need a row count formula that will only count the cells with a value inside of them.

    Unable to release any data to show information as this is work for Wakefield City Council and I'm unable to release it due to the Data Protection Act.

    Many thanks,
    Muffle

  2. #2
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    7,567

    Default Re: How to count formulas countaining any values.

    Try this:
    =COUNTA(G1:G20)
    Or

    =COUNTA(G:G)
    Last edited by My Aswer Is This; Dec 8th, 2015 at 05:48 AM.
    Muffle likes this.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  3. #3
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    7,567

    Default Re: How to count formulas countaining any values.

    Now that I read this again if you only want to count values if they are the result of a formula then my answer would be wrong.
    Muffle likes this.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  4. #4
    Board Regular AliGW's Avatar
    Join Date
    Mar 2014
    Location
    Suffolk, UK
    Posts
    2,809

    Default Re: How to count formulas countaining any values.

    So what are we counting? Cells that contain a formula, or something else?
    Muffle likes this.

  5. #5
    New Member
    Join Date
    Nov 2015
    Posts
    12

    Default Re: How to count formulas countaining any values.

    I need this command "=ROWS($B$2:$B$35)" to only count the cells that have values for instance 1.2 and 1.4 then a blank it would miss out that blank and count the total rows as 2 not 3.

  6. #6
    Board Regular AliGW's Avatar
    Join Date
    Mar 2014
    Location
    Suffolk, UK
    Posts
    2,809

    Default Re: How to count formulas countaining any values.

    Muffle - please provide some sample data so we can visualise what you are trying to explain.
    Muffle likes this.

  7. #7
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    7,567

    Default Re: How to count formulas countaining any values.

    =COUNTA(B2:B35)

    Should work then.
    Muffle likes this.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  8. #8
    New Member
    Join Date
    Nov 2015
    Posts
    28

    Default Re: How to count formulas countaining any values.

    So, you want to count the number of cells within a range that has a number?

    try this:
    Code:
    =COUNTIF(Your range;">0")

  9. #9
    New Member
    Join Date
    Nov 2015
    Posts
    12

    Default Re: How to count formulas countaining any values.

    1.1
    0.6
    -1.5
    -1.6
    1.1
    0.2
    2.5
    -0.4
    0.7
    -0.3

    I just want a formula to count rows but not count any missing rows not containing any values.

  10. #10
    New Member
    Join Date
    Nov 2015
    Posts
    28

    Default Re: How to count formulas countaining any values.

    Quote Originally Posted by My Aswer Is This View Post
    =COUNTA(B2:B35)

    Should work then.
    This one works then

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com