| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference an Operator from a cell with Sumproduct
I am trying to reference a cell which one could key in the operator i.e. = or
or < or = etc.... I want my sumproduct formula to reference this cell and use the operator instead of hardcoding the symbol inside. Essentially I want to let the user choose the operator within the sumproduct formula. Thanks in advance. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reference an Operator from a cell with Sumproduct
Something like this (placed in E1, perhaps) may work for you:
=SUMPRODUCT(--(A1:A5=D1), --(B1:B5=10),--(C1:C5)) Also, this is a great resource for things pertaining to SUMPRODUCT: http://www.xldynamic.com/source/xld.SUMPRODUCT.html Regards, Ryan-- -- RyGuy "deeds" wrote: I am trying to reference a cell which one could key in the operator i.e. = or or < or = etc.... I want my sumproduct formula to reference this cell and use the operator instead of hardcoding the symbol inside. Essentially I want to let the user choose the operator within the sumproduct formula. Thanks in advance. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reference an Operator from a cell with Sumproduct
However, I need the = sign in a different cell that the sumproduct
references. So, the end user can change the = to or < or = etc. I need a cell where they can change the operator and have it pull into the sumproduct formula. Thanks again. "ryguy7272" wrote: Something like this (placed in E1, perhaps) may work for you: =SUMPRODUCT(--(A1:A5=D1), --(B1:B5=10),--(C1:C5)) Also, this is a great resource for things pertaining to SUMPRODUCT: http://www.xldynamic.com/source/xld.SUMPRODUCT.html Regards, Ryan-- -- RyGuy "deeds" wrote: I am trying to reference a cell which one could key in the operator i.e. = or or < or = etc.... I want my sumproduct formula to reference this cell and use the operator instead of hardcoding the symbol inside. Essentially I want to let the user choose the operator within the sumproduct formula. Thanks in advance. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reference an Operator from a cell with Sumproduct
On Apr 23, 8:02 am, deeds wrote:
However, I need the = sign in a different cell that the sumproduct references. So, the end user can change the = to or < or = etc. I need a cell where they can change the operator and have it pull into the sumproduct formula. Thanks again. "ryguy7272" wrote: Something like this (placed in E1, perhaps) may work for you: =SUMPRODUCT(--(A1:A5=D1), --(B1:B5=10),--(C1:C5)) Also, this is a great resource for things pertaining to SUMPRODUCT: http://www.xldynamic.com/source/xld.SUMPRODUCT.html Regards, Ryan-- -- RyGuy "deeds" wrote: I am trying to reference a cell which one could key in the operator i.e. = or or < or = etc.... I want my sumproduct formula to reference this cell and use the operator instead of hardcoding the symbol inside. Essentially I want to let the user choose the operator within the sumproduct formula. Thanks in advance. How many possible operators? You could just do a long series of IF statements based on the contents of that cell if it isn't too many. Perhaps use data validation on that cell to make it work properly. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Reference an Operator from a cell with Sumproduct
Thanks! I ended up using if statements, it does get to be a cumbersome
formula. I really wish there were some way to have a user enter the operator and have that cell be referenced from within sumproduct formula. Anwyways, thanks for the help! "Spiky" wrote: On Apr 23, 8:02 am, deeds wrote: However, I need the = sign in a different cell that the sumproduct references. So, the end user can change the = to or < or = etc. I need a cell where they can change the operator and have it pull into the sumproduct formula. Thanks again. "ryguy7272" wrote: Something like this (placed in E1, perhaps) may work for you: =SUMPRODUCT(--(A1:A5=D1), --(B1:B5=10),--(C1:C5)) Also, this is a great resource for things pertaining to SUMPRODUCT: http://www.xldynamic.com/source/xld.SUMPRODUCT.html Regards, Ryan-- -- RyGuy "deeds" wrote: I am trying to reference a cell which one could key in the operator i.e. = or or < or = etc.... I want my sumproduct formula to reference this cell and use the operator instead of hardcoding the symbol inside. Essentially I want to let the user choose the operator within the sumproduct formula. Thanks in advance. How many possible operators? You could just do a long series of IF statements based on the contents of that cell if it isn't too many. Perhaps use data validation on that cell to make it work properly. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumproduct - cell reference | Excel Worksheet Functions | |||
| Why doesnt union reference operator work with COUNTIF? | Excel Discussion (Misc queries) | |||
| How to use a cell value as operator in a worksheet reference? | Excel Worksheet Functions | |||
| SUMPRODUCT and OR operator | Excel Worksheet Functions | |||
| SUMPRODUCT Criteria Via Cell Reference?? | Excel Worksheet Functions | |||
Linear Mode
