countif + match formula

**jw01** · 01-26-2011, 11:57 AM

hello daddylonglegs
again, thx you for your time. it worked out perfectly...thxs for all your kind help/prompt response!!

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.

**NBVC** · 01-26-2011, 11:59 AM

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...