Counting blank cells in a closed workbook

[Roan242]

afternoon, i need to count blank cells in a closed work book where the range being counted contains formulas which return either a value or a blank. i need to count all the blanks.

any one suggest a way?

thank you

[NBVC]

Try Sumproduct:

e.g.

=SUMPRODUCT(--('C:\Documents and Settings\My Documents\\[MyWorkbook.xls]Sheet1'!$G$5:$G$20=""))