software

How all i have two problems im hoping you can help me solve

Firstly

i have a list of numbers and i want to count all the entries that are
less than -0.1 and higher then 0.1Secondly
I want to sum the umbers that are over 0.1 and less than -0.1

example (as this one's a bit more complicated)

0.13 (0.03 over)
0.05 (in target)
-0.25 (0.15 over)
-0.08 (in target)

sum 0.18All the help you guys give is always much appreciated,

ceemo--
ceemo
------------------------------------------------------------------------
ceemo's Profile: www.excelforum.com/member.php...oamp;userid=10650
View this thread: www.excelforum.com/showthread...hreadid=510717Try...

=SUMPRODUCT(--(ABS(A1:A100)gt;0.1))

and

=SUMPRODUCT(--(ABS(A1:A100)gt;0.1),ABS(A1:A100)-0.1)

Hope this helps!

In article gt;,
ceemo gt; wrote:

gt; How all i have two problems im hoping you can help me solve
gt;
gt; Firstly
gt;
gt; i have a list of numbers and i want to count all the entries that are
gt; less than -0.1 and higher then 0.1
gt;
gt;
gt; Secondly
gt; I want to sum the umbers that are over 0.1 and less than -0.1
gt;
gt; example (as this one's a bit more complicated)
gt;
gt; 0.13 (0.03 over)
gt; 0.05 (in target)
gt; -0.25 (0.15 over)
gt; -0.08 (in target)
gt;
gt; sum 0.18
gt;
gt;
gt; All the help you guys give is always much appreciated,
gt;
gt; ceemo