View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alexey[_3_] Alexey[_3_] is offline
external usenet poster
 
Posts: 11
Default 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.