This is driving me nuts. For some reason I can't seem to find the function that tells me the amount of data points between two set points. In particular I'm looking for data between 70-150. The best Excel help gave me was:
=SOM(ALS(A2:A7="Blaauboer";ALS(B2:B7<9000;1;0)))
My Excel is in dutch but if you can give hints in English, I'll be able to work it out. It's office 2007 by the way.
Thanks in advance.
The Doctor will see you now
Promoting Lesbianism --> 







