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


--
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

Hi Yunus,

It's an array formula. So you have to confirm with Ctrl+Shift+Enter.
i.e,
Hold down the Ctrl and Shift keys while hitting Enter key.


You can also try this,

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

Normal Enter

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
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"
wrote in message
...

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

People,
Just want to say thanks for the 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