So on every day of the month, there is a column for the operator to put a "Y" if they have checked and filled out the excel workbook. The default has a "N" in the cell. In my summary workbook, I want it to search across all the workbooks in the folder and tally the number of workbooks that have a "N" in the cell, which is cell F7. Could someone please help me with a formula for this? I have been trying to make +SUMIF work, but I just can't wrap my head around it. Thanks for your help!