By using this site, you agree to our Privacy Policy and our Terms of Use. Close

Forums - General - Need some help with excel

Esmoreit on 22 August 2008

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 -->

                              

Around the Network
nordlead on 22 August 2008

there is a function called "COUNTIF" that takes a range of cells, and counts them if the conditional for that cell is met. I've used it before, but not in the past year or so, so I don't remember much about it.




If you drop a PS3 right on top of a Wii, it would definitely defeat it. Not so sure about the Xbox360. - mancandy
In the past we played games. In the future we watch games. - Forest-Spirit
11/03/09 Desposit: Mod Bribery (RolStoppable)  vg$ 500.00
06/03/09 Purchase: Moderator Privilege  vg$ -50,000.00

Nordlead Jr. Photo/Video Gallery!!! (Video Added 4/19/10)