Sumif function help

B

Bob Phillips

Use SUMPRODUCT instead of SUMIF, as that works fine with closed workbooks.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top