Posted to microsoft.public.excel.misc

David

external usenet poster

Posts: 1,560

Sumifs

Hi,

I link sumifs function to another worksheet and whenever I recalculate the
sheet with the sumifs functions with the linked pages closed, I get the
#VALUE! error. Any idea how to avoid this error and have the function either
pull the data or keep what ever answers I had in the cell before it was
updated?

Thank you,

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
SUMIFS	Steen	Excel Worksheet Functions	5	November 2nd 08 03:38 PM
SUMIFS and OR	mohavv	Excel Discussion (Misc queries)	4	January 30th 08 04:02 PM
SUMIFS	Mark	Excel Discussion (Misc queries)	3	November 28th 07 12:09 PM
SUMIFS and OR	M.S. Westerbeek	Excel Worksheet Functions	6	August 23rd 07 07:24 PM
SumIfs	timson	Excel Discussion (Misc queries)	3	January 26th 07 07:46 PM

All times are GMT +1. The time now is 07:18 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us