Posted to microsoft.public.excel.misc

Joe M.

external usenet poster

Posts: 97

#N/A error in sumproduct

Here is my formula:
=SUMPRODUCT((Data!$E$2:$E$3000=$A$1)*(Data!$C$2:$C $3000=$A3)*(Data!$D$2:$D$3000="N"))
If I remove the last segment *(Data!$D$2:$D$3000="N") then I get a result.
When it's included I get #N/A. In Data!D2:D3000 is the result of an =if that
results in Y or N. I also tried changing the =if to 1 or 0 with the same
result.
Can someone help?
Thanks!
Joe M.

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
#N/A error in sumproduct	Paul C	Excel Discussion (Misc queries)	0	December 9th 09 10:33 PM
another sumproduct with #value error...	Maya[_2_]	Excel Worksheet Functions	5	September 21st 09 02:19 PM
SUMPRODUCT #VALUE! error	Chris Slowe	Excel Worksheet Functions	2	June 19th 07 05:00 PM
Sumproduct error	Curtis	Excel Worksheet Functions	2	October 29th 06 10:18 PM
#ref error with Sumproduct	[email protected]	Excel Worksheet Functions	5	October 9th 06 07:00 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us