| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding multiple workbooks together | Excel Discussion (Misc queries) | |||
| Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
| linking to multiple workbooks | Excel Discussion (Misc queries) | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
| Multiple worksheets, multiple workbooks | Excel Worksheet Functions | |||
Threaded Mode
