Macro for calculating stats(ie, Average) over variable range

Hi All,

I have a macro (unsuccessfully) started to help me automate calculating statistics for a variable set of data.

Please Login or Register  to view this content.

The problem is, this code seems unnecessarily long, and also will not work if I have labels in the rows and columns (ie, text for headers in columns), as well as the first few column's data consisting of names and text associated with the numeric data I need to calculate statistics for.

An example is below, and is to be read as a worksheet (Capital letters represent the labeled column headers).

Please Login or Register  to view this content.

Any help or insight would be greatly appreciated.

Thanks in advance.

-P

Hi,

Please attached example workbook than its more easy to solve ur query.

Sure, probably should have added to the original post. It's attached now.

I deleted the irrelevant macros because the module was pretty crowded, but left the results they produced for the starting point of the macro(s) I'm having trouble with.

My end goal is to produce the stats on the "Stats2" sub in the sheets labeled "Stats01" and "Stats02." It will ideally produce a set of separate stats for the students by section.

My work so far is pretty messy, but hopefully isn't too difficult to interpret.

Thanks

-P

Hi Par,

Please find the attached workbook and plz have review and let me know is it that u want output or not.

Thanks - Naveed.

Yep, that's it exactly. Thanks a lot, I really appreciate the help.

K thanks to u as well brother i also learn new thing equally .