If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Bring Back Qualified Sum from another WB
I'm in WB Main.xls with 4100 as text in cell D6;
I'm trying to bring back the qualified sum - taken from another WB names Feb2005Deposits.xls, without Success.. Can someone assist? TIA, =SUM(([Feb2005Deposits.xls]DepositsForMonth! $G$6:$G$3561="Reg")*([Feb2005Deposits.xls]DepositsForMonth! $K$6:$K$3561=$D6)*([Feb2005Deposits.xls]DepositsForMonth! $C$6:$C$3561)) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I adore Microsoft PhotoDraw, and I hope you will bring it back. | kulakai | General Discussions | 0 | March 2nd, 2005 06:53 AM |
how do I have my returned e-mails not come back to my inbox with . | John Lancia | Database Design | 1 | February 17th, 2005 08:40 AM |
Bring back 30-day calendars and Task list display (2000/XP view) . | Ken Nowack | Calendar | 1 | December 20th, 2004 07:15 PM |
Bring back NetFolders for Outlook so I can synch with other users. | NetFolders fan | Contacts | 1 | November 17th, 2004 02:10 PM |
Bring back Netfolders! | shealy | Contacts | 1 | October 15th, 2004 06:21 PM |