It's OK, I sorted it.
In AH5, I put
then filled it all the way down. I then did a sum at the bottom to find the total number of rows.
In AH5, I put
Code:
=IF(AG5=0;0;1)
Calculating the number of rows which have a certain criteria
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.
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
Those are 2 different things.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.
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)
Thanks!=COUNTIF(AG:AG,"<>"&0)
1 - 4 of 4 Posts
- Status
- Not open for further replies.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
