count it
 

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.1


Secondly
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.18


All the help you guys give is always much appreciated,

ceemo


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=510717

count it
 

Try...

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

and

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

Hope this helps!

In article ,
ceemo wrote:

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.1


Secondly
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.18


All the help you guys give is always much appreciated,

ceemo