If all you want to do is resolve the circular reference, move it to a
different cell. However, this is unlikely to solve your problem. To do that,
you need to tell us what problem you want solved. Without knowing that,
we're only guessing. My guess is you want the following in C1:

SUMPRODUCT(C2:C6 * (A2:A6 = B1))

Regards,
Fred.

"Alexey" wrote in message
...
Please help me to resolve circular reference calculation error

A B C
1 vegetable
2 fruit apple 5
3 fruit
4 fruit orange 6
5 vegetable potatoes 5
6 vegetable onion 6

When I place next formula to the column C in empty cells I receive
circular
reference error How can I avoid it?
C1 = SUMPRODUCT(C1:C5 * (A1:A5 = B1))