# Calculating the number of rows which have a certain criteria

1559 Views 3 Replies 2 Participants Last post by  cowplopmorris
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.
Status
Not open for further replies.
1 - 4 of 4 Posts
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.
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.
Those are 2 different things.

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)
=COUNTIF(AG:AG,"<>"&0)
Thanks!
1 - 4 of 4 Posts
Status
Not open for further replies.