Hi
Yeah, I'd imported the codes (and some other data I was using) and it looks
like they were treated as text. As soon as I resolved that it sorted the
problem. Thanks very much for your help and sorry for the typo at the start
of all this that complicated matters!
"KL" wrote:
Hi FlamencoKid,
This probably suggests that some of the ranges used contain text values that
can not be forced into a number. I would rather try DataText to Columns...
etc.
Regards,
KL
"FlamencoKid" wrote in message
...
Hi
Tried your suggestion and the result was #VALUE! Does this mean the source
data was text? If so, should I Edit Paste Special and turn it to a value?
Thanks a lot for your help
"KL" wrote:
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.
|