MS Excel Function Syntax Help
Posted on 2001-08-10
here is what I am attempting to do I will show the example first then ask the question:
Example: Cell A1 is 5000
A2 is 7000
A3 is 7500
A4 is 8000
A5 is 10000
A6 is 15000
A7 is 20000
now using a function either Count or countif in Cell A10 what I am trying to do is Count the cells that are between the range of 5000 and 10000. Now I have tried this several times but either i get invalid or a 0 when I try to use the <> signs in my formulas.
for Example this formuala produces a 0.
now if I place just the =>5000 I get a value of 1. But what I am trying to do is get it to count all of the cells between the two numbers.
Understand this is an example, My real data has over 400 entries and its not just some simple counting so I really need the function to work.
Any help would be appreciated.