Posted to microsoft.public.excel.programming

Ram

external usenet poster

Posts: 138

Evaluate sumproduct question

When I use the code below I receive the #value! error message. Can someone
explain what i'm doing wrong?

Range("b27") = Evaluate("=sumproduct((active!A1:A24
=01/01/2005)*(ACTIVE!C1:C24=614546)*ACTIVE!D1:D24))")

Thanks for your time and 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() Question	Harvey[_2_]	Excel Discussion (Misc queries)	4	August 10th 08 09:42 PM
Sumproduct question	wx4usa	Excel Discussion (Misc queries)	1	July 30th 07 11:52 PM
Why won't Sumproduct funciton evaluate this data	[email protected]	Excel Worksheet Functions	1	March 8th 06 07:56 PM
A simple question -- Evaluate()	kaon[_12_]	Excel Programming	2	July 13th 04 10:28 AM
Evaluate - Sumproduct GRRR	Paul M.	Excel Programming	2	July 25th 03 04:17 AM

All times are GMT +1. The time now is 05:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us