This is my current sumifs formula:

=SUMIFS('[4-204 1208.xls]JE DATA'!$E:$E,'[4-204 1208.xls]JE
DATA'!$B:$B,A5,'[4-204 1208.xls]JE DATA'!$C:$C,$F$2)

It currently works as is, but i'd like to see try this Sumproduct function
sounds like a better solution.

Thanks,

David

"T. Valko" wrote:

Whatever you use SUMIF/SUMIFS to do you can use SUMPRODUCT to do.

--
Biff
Microsoft Excel MVP


"David" wrote in message
...
I see where you're going with the sumproduct, but that's not exactly what i
need. I'm trying to match

"T. Valko" wrote:

SUMIF/SUMIFS don't work on closed files. Use SUMPRODUCT instead.

--
Biff
Microsoft Excel MVP


"David" wrote in message
...
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,