137
« on: February 19, 2019, 05:58 PM »
without knowing the format of your spreadsheet it's difficult to provide accurate answers
that said, don't make things harder for yourself than they need to be, ie let excel do the calculations for you (thats what its for after all) by setting up a couple of fields in the source workbook
the counta formula counts the number of fields (cells) in a range that are not blank, eg =counta(A:A). add '-1' to account for header rows
The countif/countifs function counts the number of occurrences of defined values within a range, eg =countifs(UDE!$AC:$AC,"Low",UDE!$AC:$AC,"MLD") + countif(UDE!$G:$G,"High")
percentages are calculated by dividing the results of your 2 counta formula's, eg =counta(B:B)/counta(A:A). Note that the proper way to do this would be to substitute the relevant cell references for the counta functions
can't give you any advice regarding the extraction of the results to another document without knowing more about where and how the source files are stored. Mail merge may work, but I can't test it against your scenario