Hey Guys,
Attached is the sample file of my work. Basically am trying to analyse on surveys and have been using custom formulae to get my results. In this sample, I have varying records (rows) of surveys, varying conditions on rows, and even the varying columns from where I need to collate the ratings of those surveys. I have created the formulae. But now as they are SUMPRODUCT, I would like to implement it via WORKSHEET FUNCTION in VBA (as SUMPRODUCTs sucks up good amount of memories). Why..? basically, I have thousands and thousands of rows through which I need to get my solutions it takes hell lot of time in Cell calculations so need to make it just fixed values and would put the formulae only when we need to make a calculation.
Need assistance to perform the same operation using WORKSHEET FUNCTION and not FormulaR1C1 / Formula. The reason is because there will be dynamic movements of columns or maybe additions - So need the function to perform operations - based only on the parameters that I supply to them.
Bookmarks