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,

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

Try this instead

Please Login or Register  to view this content.

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

ABS of a range

Re: ABS of a range

Re: ABS of a range

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions