Value error sumif external link

Starbucks_33

Active Member
Joined
Jun 16, 2008
Messages
345
Hi,

I am using excel 2007. I have a Sumif formula linked to another workbook. Some times the "Value" error pops up seemingly at random. This goes away if I open up the linked workbook and then close it.

Is there something causing this error + how to fix.

Thanks!
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Yes - if the target workbook is going to be closed, you need to use SUMPRODUCTs, not SUMIFs as SUMIFs fail when the workbook they reference isn't open.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,532
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
SUMIF does not work with closed workbooks. (nor does COUNTIF). You should use SUMPRODUCT instead if you need the other workbook closed.
 

Forum statistics

Threads
1,085,542
Messages
5,384,323
Members
401,887
Latest member
Somesh

Some videos you may like

This Week's Hot Topics

Top