Then the only reasonable explanation I see is that your values are in
reality text strings and not numeric values. As a test try the following
formula and if it works then you know where the issue is:

=SUMPRODUCT((--Data!$C$2:$C$5000=100000)*(--Data!$C$2:$C$5000<=199999)*(--Data!$E$2:$E$5000))

Regards,
KL


"FlamencoKid" wrote in message
...
Sorry, typo on my part! Should have been <=199999 and it still doesn't
work :)

Any thoughts?

"Ragdyer" wrote:

Change:

$C$2:$C$5000=199999

TO:

$C$2:$C$5000<=199999
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"FlamencoKid" wrote in message
...
Hi

Values for criteria that I'm looking at are in column C, values to sum
are
in column E. I'm trying to add together (not count) all the amounts in
column
E that have corresponding values in C between two numbers. The
following
formula produces 0 when I know (I can see) that there are rows that
match
the
criteria.

The numbers in column C are codes for products by the way and they
won't
necessarily be consecutive.

=sumproduct((Data!$C$2:$C$5000=100000)*(Data!$C$2 :$C$5000=199999)*(Data!$E$2:$E$5000))

Any help greatly appreciated - this is driving me nuts! I swear I got
it
working at one stage but now it no longer seems to work.