Posted to microsoft.public.excel.misc

goss[_2_]

external usenet poster

Posts: 15

sumproduct with boolean criteria returns unexpected 0

Hi all -

My sumproduct formula is measuring 2 criteria
-Values < 0?
-Period = P1

But it is returning a #N/A error
Can anyone give me a nudge in the right direction?

=SUMPRODUCT((Data!$D$2:$D$20000)*(Data!$E$2:$E$20 00=Summary!$K$2))/
1000

Thanks.
Best regards,
markc

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
Using booleans in sumproduct formulas to extract boolean range	ExcelMonkey	Excel Worksheet Functions	4	April 4th 07 12:06 AM
Database Function Criteria Boolean Operations	ampozdol	Excel Worksheet Functions	4	August 18th 06 10:40 PM
SumProduct Returns Zero	ronnomad	Excel Worksheet Functions	4	August 10th 06 02:45 PM
sumproduct returns zero	vacation	Excel Worksheet Functions	7	January 31st 06 07:56 PM
boolean find criteria in Excel	davista00	Excel Discussion (Misc queries)	1	December 1st 04 03:45 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us