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