Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need assistance with a formula - If then???
I need to determine how often a number occurs in a range of cells above and
below a certain value. The range is 71 cells. I need to know how many times the number is above 120 and below 120. I then need to know the percentange of the range that was above 120 and below 120. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need assistance with a formula - If then???
Try this for an example
=COUNTIF(A1:A10,"120") "Bookmdano" wrote: I need to determine how often a number occurs in a range of cells above and below a certain value. The range is 71 cells. I need to know how many times the number is above 120 and below 120. I then need to know the percentange of the range that was above 120 and below 120. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need assistance with a formula - If then???
Please don't multipost. Cross-post if you must.
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html -- David Biddulph "Bookmdano" wrote in message ... I need to determine how often a number occurs in a range of cells above and below a certain value. The range is 71 cells. I need to know how many times the number is above 120 and below 120. I then need to know the percentange of the range that was above 120 and below 120. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need assistance with a formula - If then???
On Oct 2, 11:11 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote: Please don't multipost. Cross-post if you must.http://www.cs.tut.fi/~jkorpela/usenet/xpost.html -- David Biddulph "Bookmdano" wrote in message ... I need to determine how often a number occurs in a range of cells above and below a certain value. The range is 71 cells. I need to know how many times the number is above 120 and below 120. I then need to know the percentange of the range that was above 120 and below 120.- Hide quoted text - - Show quoted text - TRY THIS. =(COUNTIF(B3:B25,"<120")/(COUNT(B3:B25))) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Assistance Please | Excel Worksheet Functions | |||
Formula Assistance Please | Excel Worksheet Functions | |||
Formula Assistance ( | Excel Worksheet Functions | |||
Formula Assistance | Excel Discussion (Misc queries) | |||
Formula Assistance | Excel Worksheet Functions |