Circular reference help
=SUMPRODUCT(C2:C3 * (A2:A3 = B1))
Alexey wrote:
Please help me this the next situation
A B C
1 fruit
2 fruit apple 5
3 fruit orange 6
In C1 I want to use SUMPRODUCT(C1:C3 * (A1:A3 = B1)), but receive Circular
reference calculation error.
|