Countifs multiple criteria, and 1 criteria Less than & Greater than

[david gonzalez]

Hi friends !!

I'm using a Countifs function (with the assistance of a Helper columns) and i would-like to Add to the "F Column" a function to take in account if values ' Greater than 4 Less than 10'

I searched some sites and still i'm not clear where exactly do i have to Add the tinghi "< / > "
This is the function that i'm using :

Please Login or Register  to view this content.

Thank you so much In Advance.



Best Regards

David

[rcm]

Please Login or Register  to view this content.

Since it is not clear, I show an example to test in the countif for less than,

[Tony Valko]

I didn't download your file.

Try this...

=COUNTIFS($F$3:$F$1001,">4",$F$3:$F$1001,"<10",$P$3:$P$1001,
$D3,$T$3:$T$1001,$H3,$U$3:$U$1001,$I3,$R$3:$R$1001,$F3)&" Times"

[david gonzalez]

Hi,

It worked !!!

Thank you so much !!!!!!!




Best Regards

David

[Tony Valko]

You're welcome. Thanks for the feedback!