Circular reference help
 

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.

Circular reference help
 

I think you want:

=SUMPRODUCT((C2:C3)*(A2:A3=B1))

Or, you could do it like:

=SUMIF(A2:A3,B1,C2:C3)

Hope this helps.

Pete

On Sep 19, 3:03*pm, 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.

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.

Circular reference help
 

Ok, Thanks

But actually I have a little bit more complex case (I don't konow the order)
A B C
1 fruit apple 5
2 fruit
3 fruit orange 6
4 vegetable potatoes 5
6 vegetable onion 6
5 fruit

And in column C in empty cells I need to place something like
SUMPRODUCT(C1:C5 * (A1:A5 = B2)) or
SUMPRODUCT(C1:C5 * (A1:A5 = B5))


"Pete_UK" wrote:

I think you want:

=SUMPRODUCT((C2:C3)*(A2:A3=B1))

Or, you could do it like:

=SUMIF(A2:A3,B1,C2:C3)

Hope this helps.

Pete

On Sep 19, 3:03 pm, 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.