I made things too complicated.... use countif
I have a large list. I need a formula that will count all the values in the list that are lower than a certain value. I tried to use the following formula but that returned the total for the full list.
Anyone know where I went wrong?
Last edited by AAE; January 24th, 2012 at 09:00. Reason: remove code tags from formula
That's why I come to this board - I've learned enough to be dangerous but I need people like you Smallman to keep me in check!
I've got a new problem branching off of this, but I can't seem to get it to work just right.
So I have another column (call it A) that is filled with 1 or 0. How do I count the number of rows where column A = 1 and column G is between 20,000-40,000 (or you could just say <20,000 to keep it simple)?
I am sorry I did not see your earlier response showing you had a solution.
What version of XL are you on? If you are using XL 2007 or later the following is a workable solution for you.
I have attached a file just in case you have a recent version of XL.
Don't worry about showing the formula twice... I need all the reinforcement that I can get
Luckily I have xl 2011 so that formula works. Thanks for making things simple!
You're helps been very much appreciated today, Smallman. Thank you
If want the criteria in the formula to be dynamic, you can use this version:
Where cells A1 and B1 are input cells.
Obviously, adjust the references as required.
There are currently 3 users browsing this thread. (0 members and 3 guests)