absolute value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

he is what i need to do. i want to count the absolute value of a range if it is greater or equal to 2,000,000. if it is -2,000,000 in need it to first get the absolute number and then count it. this is the formula that isn't workin

=countif(abs(a1:a9), ">=2000000) any suggestions?
 
Did you type that formula in rather than cutting and pasting? You are
increasing the chance that you screw up with a typo, and we then wouldn't
are not seeing the actual formula which fails for you. For example your
formula is missing a quote, even it it were going to work (which it
wouldn't) it would fail there for that reason.

=SUMPRODUCT(--(ABS(A1:A9)>=2000000))


buege said:
he is what i need to do. i want to count the absolute value of a range if
Click to expand...
it is greater or equal to 2,000,000. if it is -2,000,000 in need it to
first get the absolute number and then count it. this is the formula that
isn't working
 
Dave R. said:
Did you type that formula in rather than cutting and pasting? You are
increasing the chance that you screw up with a typo, and we then wouldn't
are not seeing the actual formula which fails for you. For example your
Click to expand...

Yes, this is a good example of errors made while typing!
 
Back
Top