Solved

# MS Excel Function Syntax Help

Posted on 2001-08-10

Hello,

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.

=COUNTIF(C4:C10,"=>5000 =<10000")

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.