Re: SUMPRODUCT error - help diagnosing

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: jeff.fry@xxxxxxxxx
Date: 10 Mar 2006 15:06:43 -0800

whoops, sorry - typo in my initial post. Thanks JeffMelton for the
catch!

THIS WORKS:
=SUMPRODUCT(('found-data'!$A$2:$A$10219>'found-summary'!$A6)*('found-data'!$A$2:$A$10219<'found-summary'!$A6+1)*('found-data'!$B$2:$B$10219='found-summary'!C$4))

AND THIS DOESN'T:
=SUMPRODUCT(('found-data'!$A$2:$A$10219>'found-summary'!$A6)*('found-data'!$A$2:$A$10219<'found-summary'!$A6+1)*('found-data'!$B$2:$B$10219='found-summary'!C$4)*('found-data'!F2:F10219='new
interface'))

Any ideas?

.

Follow-Ups:
- Re: SUMPRODUCT error - help diagnosing
  - From: JeffMelton

References:
- SUMPRODUCT error - help diagnosing
  - From: jeff . fry
- Re: SUMPRODUCT error - help diagnosing
  - From: JeffMelton

Prev by Date: Re: Button to create a new tab
Next by Date: Any way to know in SheetChange event that Find/Replace was invoked?
Previous by thread: Re: SUMPRODUCT error - help diagnosing
Next by thread: Re: SUMPRODUCT error - help diagnosing
Index(es):
- Date
- Thread