Posted to microsoft.public.excel.programming

Simon[_9_] Simon[_9_] is offline

external usenet poster

Posts: 2

Using SUMIF with linked sheets

I've tried using SUMIF with linked sheets and it has some problems.
i.e.
=SUMIF('D:\temp\[123.xls]Aug'!$A:$A,AS!C9,'D:\temp\[123.xls]Aug'!$G:$G)

The cells returns #VALUE.
But when I open the linked sheet (123.xls), the formula works fine.

Does anyone have any workarounds ?

Thanks,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sumif linked to different workbook	JLC1952	Excel Worksheet Functions	1	April 17th 09 06:08 PM
SumIF linked to another spreadsheet	ChrisN	Excel Discussion (Misc queries)	7	February 24th 06 09:46 AM
Linked sheets	Micos3	Excel Discussion (Misc queries)	6	February 15th 06 03:58 PM
SumIf - Linked Workbook - #VALUE	Lynn	Excel Worksheet Functions	1	October 5th 05 09:54 PM
SUMIF linked WBs giving OUT OF MEMORY	Carl @ Flo-Products	Excel Worksheet Functions	0	February 8th 05 07:09 PM

All times are GMT +1. The time now is 10:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us