countif + match formula

Originally Posted by jw01

also nbvc, i really apprecaite your feedback and help with this matter. i realize the sumif only works if the workbook is open, which is fine for now; however for future reference or knowledge, is there a way to go around this? thx you.

Usually, Sumproduct() is the replacement for COUNTIF or SUMIF when working with closed workbooks...