Here is the question in full:
Hi
I seem to be tied up on problems of a similar nature. In this one, I am interested in working out whether or not countif can be used as a condition in a complex sumif function.
I am interested in the equivalent of a sumifs function in which the sum range is instead the result of a calculation involving two cells of data, and one of the conditions is a countif function of another array of data.
Here is an example to clarify my question:
A B C D
1 C 4 ?
2 I 5 ?
3 C 6 ?
The desired formula would be a functioning version of:
sumifs( (a1+c1)*c1, countif($b$1:$b$3,b1),>1). It would give the following values in column D: 20; 0; 54.
The desired formula would also allow modification of the calculation (a1+c1)*c1, so that different calculations could be performed (such as with more than two columns of data) with the same countif type conditionality.
Let me know if I have been unclear and I will try to rephrase my difficulty.
On a more general note, I would appreciate any interpretation of suitable formulas since I come across problems of a similar nature often but don't believe I understand how they work and can be adapted.
Kind regards
i_excel