Using a sum/subtract as a condition in a countifs formula

[i_excel]

Hi

I am trying to use a summation/subtraction in a countifs formula, but it's not working out for me. I am wondering whether or not this can be done, and if so, how? Below is an example of the problem, which I hope clarifies my question:

A B C
C 1 4
G 2 3
I 3 2
C 4 1

I would like to use a formula like: countifs(a1:a4,"C", (b1:b4)-(c1:c4),>3), which for the above example should return a value of 2. The subtraction condition should only be imposed on the subtraction of values on the same row.

Let me know if I haven't explained my difficulty clearly enough and I will endeavour to rephrase the problem.

Kind regards
i_excel

 

[i_excel]

Thank you James006, that worked as desired. And thank you both for enduring me. XOR LX, I agree with your latest post. I tried to rectify the problem with my post at 5:51pm, but it remains a confusing thread.

Kind regards
i_excel

 

[James006]

Glad you have managed to sort it out ...

I can testify XOR LX is a lot more patient than myself ... with all the twisted issues he has so kindly fixed for me ...

Cheers

James

 

[XOR LX]

I can testify XOR LX is a lot more patient than myself ... with all the twisted issues he has so kindly fixed for me ...

That's kind of you to say so, but I think the issue here was less one of patience than more one of understanding, of which you seem to have demonstrated more than I did in this thread.

Cheers

 

[James006]

XOR LX,

If you allow me to comment on BOTH your patience AND your understanding ... your phenomenal expertise does no longer need to be demonstrated ...!!!