Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I'm trying to count the number of cells within a column, that fall within a set range (50-120). I can create a formula that returns the number of cells which are greater than 50 (as below) but I'm really struggling when trying to create a formula to count the number of cells that fall within the range of 50 to 120 ? =COUNTIF(F2:F126,"50") This has been driving me made for a few hours now, so any help would be very gratefully received and probably save my hair line !! Thanks, Simon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF COMBINATION?? | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |