Home |
Search |
Today's Posts |
#1
|
|||
|
|||
countif
is there anyway to reference a cell as part of the criteria in countif
=COUNTIF(F4:Z4,"<.00202") = returns a value of 6 =COUNTIF(F4:Z4,"<a4") = returns a value of zero - even though +a4=.00202 - I believe that it is looking for the characters <a4 - rather than using this as a cell reference |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |