| 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) | |||
Linear Mode
