Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable Criteria?
I am trying to do a formula where the criteria changes from row to row. For example, in the following formula I would like to use a cell's value instead of "4" or "1": =COUNTIF(A:A,"<=4")-COUNTIF(A:A,"<=1") Is there a way to do this? If not, I will give a much larger explanation of what I am trying to do. I appreciate the help. Chris -- chris2bc ------------------------------------------------------------------------ chris2bc's Profile: http://www.excelforum.com/member.php...o&userid=29133 View this thread: http://www.excelforum.com/showthread...hreadid=488535 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable Criteria?
Use the & operator to combine the operator you want (<=) with the cell
reference containing the value: =COUNTIF(A:A,"<="& F2) --Bruce "chris2bc" wrote: I am trying to do a formula where the criteria changes from row to row. For example, in the following formula I would like to use a cell's value instead of "4" or "1": =COUNTIF(A:A,"<=4")-COUNTIF(A:A,"<=1") Is there a way to do this? If not, I will give a much larger explanation of what I am trying to do. I appreciate the help. Chris -- chris2bc ------------------------------------------------------------------------ chris2bc's Profile: http://www.excelforum.com/member.php...o&userid=29133 View this thread: http://www.excelforum.com/showthread...hreadid=488535 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable Criteria?
Ah! Thank you Bruce! Worked like a charm! --Chris -- chris2bc ------------------------------------------------------------------------ chris2bc's Profile: http://www.excelforum.com/member.php...o&userid=29133 View this thread: http://www.excelforum.com/showthread...hreadid=488535 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
How do I identify Filter criteria or variable graph title? | Excel Discussion (Misc queries) | |||
I am trying to use get pivot data with variable criteria | Excel Worksheet Functions | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
countif variable criteria | Excel Discussion (Misc queries) |