IF STATEMENT in multiple workbooks.

Hello,
Can anyone help me.

{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}

I am trying to copy the above formula for July (Jul!), but am unable to get the required figure that I need from the SAP05.xls workbook.

I have noticed that everytime I try to copy this formula the 2 'curvy' brackets at the start and end of the formula i.e. {....} don't appear. I am convinced this is the reason this formula doesn't work.
I would like to know what these curvy brackets represent and how to 'include' them in them in the formula.

Please help

People,
Just want to say thanks for the help.

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>

The curvy brackets should be entered by Excel, you don't type them.

Enter the formula

=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[
SAP05.xls]May!$K$6:$K$231)))

in a cell, and rather than Enter, hit Ctrl-Shift-Enter together. the formula
in the formula bar will then show the curly brackets if you have done it
correctly.

--
HTH

Bob Phillips

"Yunus Patel" <Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com>
wrote in message
news:Yunus.Patel.1u9mii_1124881535.4495@excelforum-nospam.com...
>
> Hello,
> Can anyone help me.
>
>
{=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,
[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile:
http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>

The curly brackets signify an array formula (you can read about them in
Excel's Help file) and they appear when you commit a formula by pressing
Ctrl-Shift-Enter

"Yunus Patel" wrote:

>
> Hello,
> Can anyone help me.
>
> {=SUM(IF([SAP05.xls]May!$C$6:$C$231=$D$2,IF([SAP05.xls]May!$E$6:$E$231=$D72,[SAP05.xls]May!$K$6:$K$231)))}
>
> I am trying to copy the above formula for July (Jul!), but am unable to
> get the required figure that I need from the SAP05.xls workbook.
>
> I have noticed that everytime I try to copy this formula the 2 'curvy'
> brackets at the start and end of the formula i.e. {....} don't appear.
> I am convinced this is the reason this formula doesn't work.
> I would like to know what these curvy brackets represent and how to
> 'include' them in them in the formula.
>
> Please help
>
>
> --
> Yunus Patel
> ------------------------------------------------------------------------
> Yunus Patel's Profile: http://www.excelforum.com/member.php...o&userid=26579
> View this thread: http://www.excelforum.com/showthread...hreadid=398525
>
>