=COUNTIF(G10:G1009,">C9")
This formula is not returning the correct result. It returns 0. I want it to count the number of rows that contain a value, which is less than that in C9. Thanks.
Dan
=COUNTIF(G10:G1009,">C9")
This formula is not returning the correct result. It returns 0. I want it to count the number of rows that contain a value, which is less than that in C9. Thanks.
Dan
You need to type it like this:
=COUNTIF(G10:G1009,">"&C9)
That will count values "greater than" C9 - contrary to what you say you want.
Flip the > to < if you want less than C9.
Last edited by Cutter; 06-17-2012 at 05:29 PM.
Thanks Cutter. Yes my mistake with > and instead of <. Thanks
Dan
You're welcome. Don't forget to mark your thread as SOLVED (click on Forum Rules @ top of page and see rule #9 for instructions - if needed).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks