Count If Function

I have a spreadsheet and all the cells have formulas that are feeding info from another spreadsheet.  Until data is entered on the master, the cell on the current spreadsheet is empty (except for the...