1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Calculating the number of rows which have a certain criteria

Discussion in 'Business Applications' started by cowplopmorris, Sep 27, 2008.

Thread Status:
Not open for further replies.
Advertisement
  1. cowplopmorris

    cowplopmorris Thread Starter

    Joined:
    Jun 7, 2006
    Messages:
    105
    Hi,
    Is there a way to print the number of rows of which their value in AG != 0?

    I have a spreadsheet with a 'total' column, and I want to find how many rows do not have £0.00 as the result.

    Any ideas?

    Thanks.
     
  2. cowplopmorris

    cowplopmorris Thread Starter

    Joined:
    Jun 7, 2006
    Messages:
    105
    It's OK, I sorted it.
    In AH5, I put
    Code:
    =IF(AG5=0;0;1)
    then filled it all the way down. I then did a sum at the bottom to find the total number of rows.
     
  3. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,546
    Those are 2 different things. :confused:

    Either way, you don't need formulas all the way down, you can do it with one.

    =COUNTIF(AG:AG,0)

    or

    =COUNTIF(AG:AG,"<>"&0)
     
  4. cowplopmorris

    cowplopmorris Thread Starter

    Joined:
    Jun 7, 2006
    Messages:
    105
    Thanks!
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/753907

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice