Circular reference help

  • Thread starter Thread starter Alexey
  • Start date Start date
A

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.
 
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
 
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))
 
Back
Top