Circular reference help

[Alexey]

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.

 

[Pete_UK]

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

 

[Bob I]

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

 

[Alexey]

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