Forgive me please for I am new! I am setting up a set of excel workbooks to track errors. There will be a workbook for every day of the month, and a workbook for a summary of the month. All of these will live in the same folder. I am using Microsoft Office Professional Plus 2010.
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!
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!