| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
absolute function - range
I am trying to count cells in selected range that are above 50 and below -50.
How can I do this without creating another row with absolute values. I tried this but it doesn't work =countif(abs(u2:u2000),"50"). |
|
#2
|
|||
|
|||
|
absolute function - range
Try this:
=countif(u2:u2000,"50")+countif(u2:u2000,"<-50") "Aleks" wrote: I am trying to count cells in selected range that are above 50 and below -50. How can I do this without creating another row with absolute values. I tried this but it doesn't work =countif(abs(u2:u2000),"50"). |
|
#3
|
|||
|
|||
|
absolute function - range
Hi there Aleks,
You can use the following ... =SUMPRODUCT(--(ABS(U2:U2000)50)) HTH -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Aleks" wrote in message ... I am trying to count cells in selected range that are above 50 and below -50. How can I do this without creating another row with absolute values. I tried this but it doesn't work =countif(abs(u2:u2000),"50"). |
|
#4
|
|||
|
|||
|
absolute function - range
Outstanding!!! Thank yoy!
How about counting cells in selected range that are btw 5 to 50 and (-5) to (-50)? "Zack Barresse" wrote: Hi there Aleks, You can use the following ... =SUMPRODUCT(--(ABS(U2:U2000)50)) HTH -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Aleks" wrote in message ... I am trying to count cells in selected range that are above 50 and below -50. How can I do this without creating another row with absolute values. I tried this but it doesn't work =countif(abs(u2:u2000),"50"). |
|
#5
|
|||
|
|||
|
absolute function - range
Possibly ..
=SUMPRODUCT(--(ABS(N2:N2000)5),--(ABS(N2:N2000)50)) Note that this will not count those equal to 50. HTH -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Aleks" wrote in message ... Outstanding!!! Thank yoy! How about counting cells in selected range that are btw 5 to 50 and (-5) to (-50)? "Zack Barresse" wrote: Hi there Aleks, You can use the following ... =SUMPRODUCT(--(ABS(U2:U2000)50)) HTH -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Aleks" wrote in message ... I am trying to count cells in selected range that are above 50 and below -50. How can I do this without creating another row with absolute values. I tried this but it doesn't work =countif(abs(u2:u2000),"50"). |
|
#6
|
|||
|
|||
|
absolute function - range
This is awesome! Zack, whoever you are, you're a GOD!
"Zack Barresse" wrote: Possibly .. =SUMPRODUCT(--(ABS(N2:N2000)5),--(ABS(N2:N2000)50)) Note that this will not count those equal to 50. HTH -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Aleks" wrote in message ... Outstanding!!! Thank yoy! How about counting cells in selected range that are btw 5 to 50 and (-5) to (-50)? "Zack Barresse" wrote: Hi there Aleks, You can use the following ... =SUMPRODUCT(--(ABS(U2:U2000)50)) HTH -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Aleks" wrote in message ... I am trying to count cells in selected range that are above 50 and below -50. How can I do this without creating another row with absolute values. I tried this but it doesn't work =countif(abs(u2:u2000),"50"). |
|
#7
|
|||
|
|||
|
absolute function - range
I've been trying to tell him that for a year. Here's Zack!
http://www.vbaexpress.com/forum/member.php?u=11 ************ Anne Troy www.OfficeArticles.com "Aleks" wrote in message ... This is awesome! Zack, whoever you are, you're a GOD! "Zack Barresse" wrote: Possibly .. =SUMPRODUCT(--(ABS(N2:N2000)5),--(ABS(N2:N2000)50)) Note that this will not count those equal to 50. HTH -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Aleks" wrote in message ... Outstanding!!! Thank yoy! How about counting cells in selected range that are btw 5 to 50 and (-5) to (-50)? "Zack Barresse" wrote: Hi there Aleks, You can use the following ... =SUMPRODUCT(--(ABS(U2:U2000)50)) HTH -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "Aleks" wrote in message ... I am trying to count cells in selected range that are above 50 and below -50. How can I do this without creating another row with absolute values. I tried this but it doesn't work =countif(abs(u2:u2000),"50"). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "COUNTU" function in Excel to count unique entries in a range | Excel Worksheet Functions | |||
| creating function (vba) with range arguments | Excel Worksheet Functions | |||
| Number range function | Excel Discussion (Misc queries) | |||
| Function that filters a list (Database) for criteria in a range a. | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
Hybrid Mode
