Posted to microsoft.public.excel.misc

Alexey[_3_] Alexey[_3_] is offline

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Circular Reference	build	Excel Worksheet Functions	1	October 19th 07 01:08 PM
Ho do I do this without a circular reference?	mmednick	Excel Discussion (Misc queries)	6	February 2nd 06 07:42 PM
'circular reference'	Rathika	Excel Discussion (Misc queries)	2	January 26th 06 04:24 AM
Circular Reference... Help!	Bhupinder Rayat	Excel Worksheet Functions	3	January 13th 06 05:10 PM
Circular reference	Pat	Excel Discussion (Misc queries)	2	January 19th 05 05:52 AM

All times are GMT +1. The time now is 06:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us