J
John
Some of my co-workers believe beyond a reasonable doubt that they have
seen formulas in their workbooks using a SUMIF work on a closed
workbook, ie no #values. Is this ever possible?
The only conclusion I can make is that the file's workbook option of
saving external reference values was enabled, and the file was saved
when all the related workbooks were open and values were actually in
the cells. Is my hypothesis correct? Or, is SUMIF not so black and
white?
Will any function (SUMIF, COUNTIF, OFFSET, etc.) requiring a range
EVER work on a closed workbook, which creates an array type reference.
Is there a list of functions that will only work with ranges, such as
SUMIF?
TIA
seen formulas in their workbooks using a SUMIF work on a closed
workbook, ie no #values. Is this ever possible?
The only conclusion I can make is that the file's workbook option of
saving external reference values was enabled, and the file was saved
when all the related workbooks were open and values were actually in
the cells. Is my hypothesis correct? Or, is SUMIF not so black and
white?
Will any function (SUMIF, COUNTIF, OFFSET, etc.) requiring a range
EVER work on a closed workbook, which creates an array type reference.
Is there a list of functions that will only work with ranges, such as
SUMIF?
TIA