Thread
:
Circular reference help
View Single Post
#
1
Posted to microsoft.public.excel.misc
Alexey[_3_]
external usenet poster
Posts: 11
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.
Reply With Quote
Alexey[_3_]
View Public Profile
Find all posts by Alexey[_3_]