Countif(table;(">"&A1)&("<"&B1))
 

This content works individualy, how can i make it work? is it any way to
count the values between A1 and <B1?

tks

The simplest is
=countif(range,"<"&b1)-countif(range""&A1)

"Micos3" wrote:

This content works individualy, how can i make it work? is it any way to
count the values between A1 and <B1?

tks

Try...

=COUNTIF(Range,""&A1)-COUNTIF(Range,"="&B1)

If your version of Excel uses the semi-colon as a separator, replace
commas with semi-colons.

Hope this helps!

In article ,
Micos3 wrote:

This content works individualy, how can i make it work? is it any way to
count the values between A1 and <B1?

tks

or
=sumproduct((a1:a22=a1)*(a1:a22<b1))

--
Don Guillett
SalesAid Software

"Micos3" wrote in message
...
This content works individualy, how can i make it work? is it any way to
count the values between A1 and <B1?

tks

In my PC is only working this formula:
=sum((countif(table;"<"&B1))-(countif(table;"<"&A1))

but i don't know why in my friends PC isn't working, but i'll find out!!!

thanks guys :)

"Don Guillett" escreveu:

or
=sumproduct((a1:a22=a1)*(a1:a22<b1))

--
Don Guillett
SalesAid Software

"Micos3" wrote in message
...
This content works individualy, how can i make it work? is it any way to
count the values between A1 and <B1?

tks