| Home |
| Search |
| Today's Posts |
|
#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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bring back the old help format! | Excel Worksheet Functions | |||
| Find a non-blank cell and bring back text a in same row | Excel Worksheet Functions | |||
| Excel 2003 back to Excel 2002 | Excel Discussion (Misc queries) | |||
| Outlook 2003 demo back to Outlook XP | Excel Discussion (Misc queries) | |||
| Roll back to previous date | Excel Worksheet Functions | |||
Threaded Mode
