ABS of a range

**table83** · 06-15-2011, 09:38 PM

I have searched and found stuff close to what I was looking for, but not exactly what I was looking for.
http://office.microsoft.com/en-us/ex...010147120.aspx

This is what I have,

=COUNTIF(BD5:BD29,">"&D8)

This is what I want, but it doesn't work. I know I'm looking for some sort of an array, but I can't get the ctr + shift + enter to throw the brackets around it.

=COUNTIF(ABS(BD5:BD29),">"&D8)

Thanks in advance

**MarvinP** · 06-15-2011, 10:23 PM

Hi table83,
If you want the absolute values to be used in the range and count them above some value in D3
Your formula which didn't work was

=COUNTIF(ABS(BD5:BD29),">"&D8)

Try this instead

=COUNTIF(BD5:BD29,">"&D8) + COUNTIF(BD5:BD29,"<"&-D8)

No CSE formula needed

Hope that is what you were looking for.

**Andy Pope** · 06-16-2011, 04:08 AM

Or

=SUMPRODUCT(--(ABS(BD5:BD29),">" & D8))

ABS of a range

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

ABS of a range

Re: ABS of a range

Re: ABS of a range

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions