Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counif greater or less than
This is my current countif statement:
=COUNTIF(J3:J33,"<-10") BUT, I want to count anytime the cells are 10 or greater positive or negative. Please help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counif greater or less than
Try =SUMPRODUCT(--(ABS(J3:J33)=10)) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=537499 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counif greater or less than
One way
=SUMPRODUCT(--(ABS(J3:J33)10)) if you are going to use countif you need to use it 2 times like =COUNTIF(J3:J33,"<-10")+COUNTIF(J3:J33,"10") -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Raza" wrote in message ... This is my current countif statement: =COUNTIF(J3:J33,"<-10") BUT, I want to count anytime the cells are 10 or greater positive or negative. Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching Values from an Array | Excel Worksheet Functions | |||
I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
I want the greater number of 2 cells to show in a separate cel | Excel Discussion (Misc queries) | |||
I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
if greater then 99 then 1 if greater then 199 then two | Excel Worksheet Functions |