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 |
#2
|
|||
|
|||
Wow! Third question today about this topic
Use an ampersand =COUNTIF(F4:Z4,"<"&A4) will work, otherwise it will look for the text string "A4" Regards, Peo Sjoblom "Brad" wrote: 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 |
#3
|
|||
|
|||
Thank you
"Brad" wrote: 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 |
Reply |
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 |