View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default 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,