Hi,

I'm very new to excel VBA programming..can any body please suggest a
easy solution for the following:

I need to use both sum and average in subtotal function on different
columns at a time..

eg: Column A : Name
Column E: Rate
Column F: net value

I want to do sum on Column F and average on Column E for every change
in column A...

Any help will be greatly appreciated..

Thanks..