advancec CountIF functions

[mike.lewis]

Hi There

I have a folder of workbooks that are all named differently however the layout of each is identical
Each workbook is an answer sheet, so in certain cells there are certain answers, these would be Yes, No, N/A or part.

What i am essentially wanting to do is have a seperate workbook that will access or read into each of the saved workbooks and count how many times a question is answered as Yes, No, Part or N/Z

Essentially this report would be used for trend reporting, the idea is to lookup other sheets and report back how many times a person is not performing a certain action

Thanks

 

[Marcelo Branco]

Hi,

Maybe this can help
http://msdn.microsoft.com/en-us/library/cc837974(v=office.12).aspx

M.