Posted to microsoft.public.excel.misc

Teddy-B

external usenet poster

Posts: 76

Sumproduct - Indirect - NOT WORKING????? Please help

=SUMPRODUCT(--($E$7:$E$499=$A7),--($K$7:$K$499=$B$6))
I cannot get the Indirect function to work with the formula above. I have
tried:
=SUMPRODUCT(--Indirect("E7:E499"=Indirect("A7"))),--Indirect("K7:K499"=Indirect("B6"))).
My Indirect formula always returns #REF when i try to modify the last part
of the formula. What am I doing wrong?

Thanks for your help.

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
Sumproduct & Indirect Functions	VBA Noob	Excel Worksheet Functions	9	July 16th 06 09:13 AM
Need help with using SUMPRODUCT with INDIRECT	anara	Excel Worksheet Functions	1	January 22nd 06 05:08 PM
Help with Sumproduct with Indirect	Rob	Excel Worksheet Functions	6	July 28th 05 09:03 PM
sumproduct & indirect	floridasurfn	Excel Worksheet Functions	3	March 14th 05 02:01 AM
Indirect range in SUMPRODUCT?	BobT	Excel Discussion (Misc queries)	2	February 16th 05 08:51 PM

All times are GMT +1. The time now is 04:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us