| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use the count if function for a range from 40-60 ?
I need to find the number of times in which a value is reported between the
range of 40-60. I need the formula for this type of calculation |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use the count if function for a range from 40-60 ?
Hi April
One way =COUNTIF(A:A,"39")-COUNTIF(A:A,"60") -- Regards Roger Govier "April" <April @discussions.microsoft.com wrote in message ... I need to find the number of times in which a value is reported between the range of 40-60. I need the formula for this type of calculation |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I use the count if function for a range from 40-60 ?
hi,
You may try the following array formula (Ctrl+Shift+Enter) =count(if((range40)*(range<60),range)) Regards, "April" wrote: I need to find the number of times in which a value is reported between the range of 40-60. I need the formula for this type of calculation |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating function (vba) with range arguments | Excel Worksheet Functions | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Count cells based on date range in another column | New Users to Excel | |||
| clock | Excel Worksheet Functions | |||
| Sum and Count Function | Excel Worksheet Functions | |||
Linear Mode
