Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Hi, My brain isn't switched on this morning, this may be more straight forward than I think... I'm trying to do a Countif function, which only counts those in the range which are between "0" and "-2". Lets say the range is $A$1 : $A$50, and contains values between -3.00 and 5.00. How can i write this countif formula? It doesnt work the way i'm trying it! Many thanks in advance JJJ -- jjj ------------------------------------------------------------------------ jjj's Profile: http://www.excelforum.com/member.php...fo&userid=7424 View this thread: http://www.excelforum.com/showthread...hreadid=471692 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Work book shared | Excel Discussion (Misc queries) | |||
Difficulties with COUNTIF. | Excel Worksheet Functions | |||
Work book formulas | Excel Discussion (Misc queries) | |||
COUNTIF formula problems | Excel Discussion (Misc queries) | |||
COUNTIF across all sheets of a workbook | Excel Worksheet Functions |