SUMIF doesn't work on closed workbooks. Never has AFAIK.

Try my SUMPRODUCT, you may be pleasantly surprised.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ChrisN" wrote in message
...
But I am adding cells, not multiplying. I'm not sure how that would help
me
add a number in another spreadsheet.

I thought I had done this in previous Excel versions, but not I don't
remember if the sumif was related to data in another spreadsheet or within
the same worksheet.

Is that what it is...that it will not work outside the open spreadsheet?
It
is weird that the only time it doesn't work is when the other spreadsheets
are closed. If they are open, it works fine.

"Bob Phillips" wrote:

Use SUMPRODUCT

=SUMPRODUCT(--(rng_to_test="test_value"),rng_to_sum)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ChrisN" wrote in message
...
I have a SumIf linked to another spreadsheet. It works if all
spreadsheets
are open, but does not work if the source spreadsheets are not open.
How
can
I solve for this. I have linked this way before Excel 2003 - but this
version doesn't seem to allow it.