| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Greater than Less Than
I need a formula that states countif numbers in Column A are greater than 30,
but less than 90. Very easy, but I don't know how to do it. My next cell would then say, countif Column A are greater than 90, but less than 120. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Greater than Less Than
=COUNTIF(A:A,"<"&90)-COUNTIF(A:A,"<"&30)
-- Gary''s Student - gsnu200764 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Greater than Less Than
Be careful (case 1: 30, <90) (case 2: 90, <120) What about equal to 90 -
these get missed I have reworded for (case 1: =30, <90) A number of possibilities a) =COUNTIF(A:A, "=30) - COUNTIF(A:A,"=90") How many are 30 or over MINUS those over 90 b) =SUMPRODUCT(--(A1:A1000=30),--(A1:A1000<90) Must be equal or over 30 AND less than 90 Do not use A:A with SUMPRODUCT but use a range c) FREQUENCY - see Help More on SUMPRODUCT For more details on SUMPRODUCT Bob Phillips http://www.xldynamic.com/source/xld.SUMPRODUCT.html J.E McGimpsey http://mcgimpsey.com/excel/formulae/doubleneg.html best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Cindy" wrote in message ... I need a formula that states countif numbers in Column A are greater than 30, but less than 90. Very easy, but I don't know how to do it. My next cell would then say, countif Column A are greater than 90, but less than 120. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Greater than Less Than
=COUNTIF(A1:A100,"30")-COUNTIF(A1:A100,"=90")
=COUNTIF(A1:A100,"90")-COUNTIF(A1:A100,"=120") -- David Biddulph "Cindy" wrote in message ... I need a formula that states countif numbers in Column A are greater than 30, but less than 90. Very easy, but I don't know how to do it. My next cell would then say, countif Column A are greater than 90, but less than 120. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula Greater than Less Than
I see your point-Thanks for the great catch.
"Bernard Liengme" wrote: Be careful (case 1: 30, <90) (case 2: 90, <120) What about equal to 90 - these get missed I have reworded for (case 1: =30, <90) A number of possibilities a) =COUNTIF(A:A, "=30) - COUNTIF(A:A,"=90") How many are 30 or over MINUS those over 90 b) =SUMPRODUCT(--(A1:A1000=30),--(A1:A1000<90) Must be equal or over 30 AND less than 90 Do not use A:A with SUMPRODUCT but use a range c) FREQUENCY - see Help More on SUMPRODUCT For more details on SUMPRODUCT Bob Phillips http://www.xldynamic.com/source/xld.SUMPRODUCT.html J.E McGimpsey http://mcgimpsey.com/excel/formulae/doubleneg.html best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Cindy" wrote in message ... I need a formula that states countif numbers in Column A are greater than 30, but less than 90. Very easy, but I don't know how to do it. My next cell would then say, countif Column A are greater than 90, but less than 120. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Greater than but less than formula | Excel Worksheet Functions | |||
| Greater than formula | Excel Worksheet Functions | |||
| Greater than formula | Excel Worksheet Functions | |||
| Greater than formula! | Excel Worksheet Functions | |||
| Less than, Greater than Formula | Excel Discussion (Misc queries) | |||
Linear Mode
