Count and IF function with 2 conditions

[Megcam2]

Any assistance would be appreciated! What's the best way to count how many numbers in a row are between two criteria, > 40 and <=70? . If there is no data in the row that is between this criteria, I don't want to count it. Here's what I have so far:


=IF((B8:J8>40),IF(B8:J8<=70,COUNT(B8:J8),0))
The above formula returns a VALUE! error.

Or do I write it this way?

=COUNTIF(B8:J8,">40<=70")
This gives a 0 value and there are numbers in my data that match this criteria.

[K m]

=countif(b8:j8,">=40")-countif(b8:j8,">=70")

[NBVC]

TRy:

=COUNTIFS(B8:J8,">40",B8:J8,"<=70")

[dilipandey]

Hi Megcam2,

Try using below array formula:-

Please Login or Register  to view this content.

See attached :- count with 2 conditions.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[Megcam2]

A big THANK YOU to you all for your fast responses. Very helpful.

[dilipandey]

You are welcome Megcam2... Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>