Excel VBA - Using CountA to total non-blank cells and calculate percentages

[Becky24]

I have a spreadsheet with headers where I am totaling columns E through I and column M and then I want to count the non-blank cells in column A and use that result to add percentages below each of the totaled columns. The number of rows could change from time to time so I need the spreadsheet to find the cells under each of the totals to enter the percentages. I’m doing a number of other things with my spreadsheet, but this part is really causing me a problem. I’ve tried a number of things, without success. I’m new to creating code in VBA and appreciate any assistance.

 

[JLGWhiz]

That is perfectly fine. I did realize what you were doing which will work just fine as all the columns I'm totalling and creating percentages for will have something in all the cells(no blank cells). The 0 means they haven't taken a course and the 1 means they have, so I'm totalling the 1's and then dividing by the total participants (row count) to get my percentages. Thank you for above though. I'll study that as it might be useful to me in the future.

You're welcome,
regards, JLG