Count particular Values from a closed workbook in Excel

[hritesh1991]

Hi Everyone !

I really need your help in this.

I have a column named "approval" and the user is required to put decision either "Y" or "N"
and I want to count the number of "Y" and number of "N" the user has filled in the workbook without opening the file ; I need this data to be filled in another work book where two column will be the there 1.number of "Y". 2. number of "N". Cant figure out how to do.

Thanks in advance

 

[Worf]

Welcome to the Forum

Look at this page: Excel Tips From John Walkenbach: A VBA Function To Get A Value From A Closed File

 

[FDibbins]

Another option (if your range isn't too too big)...
=SUMPRODUCT(--('S:\folder1\folder1.2\[file-name.xlsm]sheet-name'!$C$4:$C$126="S2"))