Hi,

I'm trying to do a dynamic sum function for a daily production given table.

File A is a summary, with many tabs for each product type. File B contains
the daily production detail.

File A has a sumif function:
* Condition range (first parameter) is located in file B, having the product
type list.
* Condition (second paramente) is provided in file A (product type).
* Sum range (third parameter) is located in file B, is the result of a match
function that looks for a given date, then returns the column number to look
for, and then brings a reference to the whole column (using OFFSET).

The problem I'm experiencing is that the cells in File A shows #REF if the
file B is closed. Is there any parameter in Excel to prevent this? (I dig in
every single option an none of them works). Or, is there any alternative
function to OFFSET to bring a whole column as array having a dynamic
parameter?

Thanks in advance.

--
Arturo Gonzalez
Guadalajara, Mexico