trying to get this formula to work. any suggestions?
=IF(L4:L33>2,countif(M4:M33,>6),"")
trying to get this formula to work. any suggestions?
=IF(L4:L33>2,countif(M4:M33,>6),"")
Why the Greater than two Criteria? Doesn't seem necessary if you are counting the number of >6 values.
=COUNTIF(M4:M33,">6")
Edit:
Whoops nevermind, I thought both 'greater than's were referencing the same column
Last edited by Speshul; 07-10-2014 at 10:17 AM.
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.
Maybe like this
=COUNT(IF(L4:L33>2,COUNTIF(M4:M33,">6")))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
L M N O 4 1 5 3 5 3 10 6 2 1 7 4 15 8 3 12
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Because I want to know how many products have a certain attribute greater than six only if there other attribute is greater than 2...
Sweet Alkey that worked. thanks for the help
Sorry, misread the formula, thought both greater thans were looking in the same column which would have made no sense ^^
Control-Shift-Enter:
{=IF(L4:L33>2,COUNTIF(M4:M33,">6"))}
Can you only have one array per sheet? I tried doing this again in a different cell for different criteria and it deleted arrray from first cell
Actually this should do it better. No Ctrl+ Shift+Enter
=COUNTIFS(L4:L33,">2",M4:M33,">6")
If you edit an array formula (such as copying the formula from the formula bar), it removes the {}'s, you have to control-shift-enter every time you click into an array formula
nevermind its working now thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks