I'm confused whether of not to use VBA, macros, or a formula.

Hello Forum,

I'm am starting to learn to use Excel to better serve the statistics people want to know on a website I'm helping out. I know very little about excel programs and the use of macro and visual basic but I am comfortable with MATLAB and some C++ programming.


I am having problems solving what would seem to be something so easy to do in MATLAB in a large spreadsheet I am working on.


Attached is a silly file (not near the scale of my actually spreadsheet) I made to help show what my goals would be. I'm working with over 400 'goals'.


What I am trying to do is calculate the sum of all the X's for a specific "week", and then the percentage complete just below that. In Matlab, I would use an 'if-else loop' inside of a 'for loop' finding the summation of all the cells containing an 'X' character in the I column.


Also, I would then like to take that sum, and divide it by the total amount of cells in that 'week' in order to find the percentage completed.


It would also be okay if I had to make each 'week' a separate sheet in excel - that is not a major concern.


If you have any ideas or suggestions about how this might be done, or need any further details about my problem, any response is dearly appreciated.

Thanks,
Andrew

See attached file where I used formulas and macro. This is the maro:

Please Login or Register  to view this content.

Regards,
Antonio

Thank you both so much. You were incredibly quick to answer and were spot on.

Again - thanks,

Andrew