| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Logical AND with SUM
Hi
Can someone please tell me how to create the parentheses { } around a formula? Instead of using just the ENTER key, I think you have to use something else. I need to make this: =SUM(('Input Forms'!$B$2:$B$38=$B8)*('Input Forms'!$F$2:$F$38='Drop Box Lists'!$A$3)) look like {=SUM(('Input Forms'!$B$2:$B$38=$B8)*('Input Forms'!$F$2:$F$38='Drop Box Lists'!$A$3))} Thanks, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Logical AND with SUM
Ctrl + Shift + Enter
HTH, Paul -- "Lauren" wrote in message ... Hi Can someone please tell me how to create the parentheses { } around a formula? Instead of using just the ENTER key, I think you have to use something else. I need to make this: =SUM(('Input Forms'!$B$2:$B$38=$B8)*('Input Forms'!$F$2:$F$38='Drop Box Lists'!$A$3)) look like {=SUM(('Input Forms'!$B$2:$B$38=$B8)*('Input Forms'!$F$2:$F$38='Drop Box Lists'!$A$3))} Thanks, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Logical AND with SUM
Wow - Paul, thank you. That was a very fast response.
Lauren. "PCLIVE" wrote: Ctrl + Shift + Enter HTH, Paul -- "Lauren" wrote in message ... Hi Can someone please tell me how to create the parentheses { } around a formula? Instead of using just the ENTER key, I think you have to use something else. I need to make this: =SUM(('Input Forms'!$B$2:$B$38=$B8)*('Input Forms'!$F$2:$F$38='Drop Box Lists'!$A$3)) look like {=SUM(('Input Forms'!$B$2:$B$38=$B8)*('Input Forms'!$F$2:$F$38='Drop Box Lists'!$A$3))} Thanks, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logical if more than 7 | Excel Worksheet Functions | |||
| Logical | Excel Discussion (Misc queries) | |||
| Logical Functions | Excel Worksheet Functions | |||
| using logical functions | Excel Worksheet Functions | |||
| Logical Value | Excel Worksheet Functions | |||
Hybrid Mode
