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

[Guest]

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

tks

 

[Guest]

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

 

[Domenic]

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!

 

[Don Guillett]

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

 

[Guest]

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: