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:

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 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

Last edited: