Combining IF and COUNTIF with no sequential range

[horizonflame]

Hi All,

I hope you can help me with a formula for this:

Firstly, determining if the criteria is met for main count to take place:

=IF((AND(Sheet1!$R3>0,Sheet1!$S3>3%)),1,0)

Then main count if criteria met (count back through range)

Countif through Sheet1!Q3,M3,I3,E3 and criteria is exact match to Q3

Many thanks for any help!

 

[etaf]

can you use a countifs ()

what is the range

COUNTIFS( Sheet1!R1:R1000 , ">0", sheett1!S3:S1000, ">0.03", range to match Q3 , not sure what is an exact match to Q3
is that range M , I and E ?

if no sequential range - what is the range ?

 

[horizonflame]

Hello, thanks for the reply

The range is stepping backwards through Q3,M3,I3,E3 counting the number of exact matches with Q3.

I only want the count to be performed if the previous criteria is met, and then replicate the formula down the rows below

Thanks

 

[Aladin Akyurek]

Hello, thanks for the reply

The range is stepping backwards through Q3,M3,I3,E3 counting the number of exact matches with Q3.

I only want the count to be performed if the previous criteria is met, and then replicate the formula down the rows below

Thanks

Q3 = 25, M3 = 0, I3 = 25, E3 = 23

Given the foregoing, what is the desired result?

 

[horizonflame]

Q3 = 25, M3 = 0, I3 = 25, E3 = 23

Given the foregoing, what is the desired result?

Hi, in your example the count result would be 1 as 25 appears once before the value changes to 0.

If it was..... Q3 = 25, M3 = 25, I3 = 23, E3 = 25, I would get a count result of 2 before the value 25 changes.

Thanks