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,

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,

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,