count it

  • Thread starter Thread starter ceemo
  • Start date Start date
C

ceemo

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

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

and

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

Hope this helps!
 
Back
Top