Need Help in Countif and Average in VBA Coding.

[YogeshGoel26]

Hi,

I have an excel workbook in which, sheet1 contains the responses from the clients and sheet2 shows the output which is generated from the sheet1.

Now I need following output:-

1. In Sheet2, C2 should be equal to Total number of responses from sheet 1.

2. In sheet2, Column B should copy the question no. from sheet1 which is starting from Row1.

3. In sheet2, Column C should show count of response whose value is greater than 3 from sheet1 against their Question No.

4. In sheet2, also show the average of Cummincation, Total Rewards etc...

I am also attaching the files for your reference. Please help me asap I need very urgently.